How to connect to upstox api in excel web query

I want to connect to my upstox account via web query in Excel. However, I am not getting any reference on how it can be achieved.

Can you please correct me on the web query part so I can connect and get all my holdings info in Excel

Any update? Ticket 7878576 was created in this regard

Hi @Harbilas_Bal,

I have passed on your query to the concerned team and they are looking into it.

Thanks for your patience.

Hi @Harbilas_Bal,

Thank you for reaching out to us with your query.

I noticed that there appears to be a syntax error, as indicated in the screenshot you provided. Our team is here to help you troubleshoot and address issues on the API front however this seems an issue with the web query part of integration.

It’s important to understand that while we are more than willing to provide assistance with the API, the specific applications and use cases may vary and should be determined by you based on your requirements. As of now, we don’t have pre-defined steps available for integrating APIs with Excel.

Thanks Abhishek! Lets break it down into pieces. First, need help to do the authentication via web query. Then, will further build the code towards getting holding info.
So, can you share workig web query on the authentication part?