Missing HTTP request header parameters

[aliadils3d]

Hello*



I have excel 2019 and the in the DATA tab yuo select FROM WEB then you select ADVANCED and below in the http request header parameters i have limited entires as per image 1, but on an another excel 2019 there are many entries. .*

so how can i get these additioanl entries to my excel*


image 1.jpgimage 2.jpg

[alansidman]

It appears that the second screen is from a On-Line Video. Would you share that link, so that we can investigate what is happening to cause the difference.

[CK76]

Instead of using dropdown. You can type in whatever header that is required for sending request.

My guess, the second image has more dropdown, since user had used various header at one point or another and it's retained in memory and provided as dropdown option.
But don't quote me on it

EDIT: Oh, another possibility is that he's using Office 365 sub on MS insider track.

[aliadils3d]

Hello

Below is the l ink as requested

https: // ww w. youtube. com/watch?v= g9DHlNpGgvw&feature=youtu.be