We couldn't Authenticate with the credentials provided

punnu07

New Member
Joined
Apr 19, 2015
Messages
34
All,

I am trying to fetch the live stocks data from NSE website and I have used the Data -> "From Web" function for the same. Below are the attributes which I have fetched from the site:

Source = Json.Document(Web.Contents("https://www.nseindia.com/api/equity-stockIndices?index=SECURITIES IN F&O",
[Headers=[#"accept-encoding"="gzip, deflate",
#"accept-language"="en-IN,en-GB;q=0.9,en-US;q=0.8,en;q=0.7",
#"user-agent"="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36", Cookie="A9A56C0BC357FC0510E4F82EA12DED02~bK5MfvH2x374rR/o1GKLSyyo2Vb22v0uHhFRPUEn/7Uj+xivH+sI2DrNX/0AxoV08EOEqnD3lVDo/w5IASQP1yX4bDlKmWxpXabu9ZEZgIXMUIaULSt+7Y2VpXE0Ujmdb4GqSujPO5oD/cF4+0p/VhsLiXTgqOdtKrKfV7Uzzqw="]])),

I am able to fetch the required table/data into the excel; however constantly I am getting below error (screenshot attached);

We couldn't authenticate with the credentials provided. Please try again.

Sometimes after just one click on connect, data get refreshed; however sometimes even after clicking 15 20 time, it is not connected.

Please help me in resolving this issue.
 

Attachments

  • error.jpg
    error.jpg
    45.2 KB · Views: 174

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,484
You need to refresh Cookie since It is expired at a certain time. Open the web page in the browser and copy the new cookie string.
 

punnu07

New Member
Joined
Apr 19, 2015
Messages
34
You need to refresh Cookie since It is expired at a certain time. Open the web page in the browser and copy the new cookie string.
Thank you for your reply. Is there any way to update the cookie automatically because manually it takes a lot of time.
 

Forum statistics

Threads
1,136,275
Messages
5,674,787
Members
419,524
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top