Mac - Data from web using REST API URL

%3CLINGO-SUB%20id%3D%22lingo-sub-1016244%22%20slang%3D%22en-US%22%3EMac%20-%20Data%20from%20web%20using%20REST%20API%20URL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1016244%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Mac%20we%20have%20option%20called%2C%20%E2%80%9CFrom%20HTML%E2%80%9D%20in%20%E2%80%9CDATA%E2%80%9D%20Tab%20of%20Excel-2016.%20We%20can%20get%20data%20which%20doesn%E2%80%99t%20need%20username%20and%20password%20which%20are%20already%20linked%20with%20Excel.%3C%2FP%3E%3CP%3EFurther%2C%20in%20Data%20tab%20we%20have%20%E2%80%9CGet%20External%20Data%E2%80%9D%20%E2%80%93%20%E2%80%9CRun%20Web%20Query%E2%80%9D%2C%20which%20stores%20the%20URL%20in%20text%20file%20which%20have%20extension%20%E2%80%9C.iqy%E2%80%9D%20format.%20Which%20also%20gets%20data%20which%20doesn%E2%80%99t%20need%20credentials.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20pass%20the%20credentials%20along%20with%20%22Data-%20From%20HTML%22%2C%20like%20i%20wanted%20to%20add%20%22Authorization%22%2C%20ContentType%22%20as%20headers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1016244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%20Excel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

In Mac we have option called, “From HTML” in “DATA” Tab of Excel-2016. We can get data which doesn’t need username and password which are already linked with Excel.

Further, in Data tab we have “Get External Data” – “Run Web Query”, which stores the URL in text file which have extension “.iqy” format. Which also gets data which doesn’t need credentials.

 

Is there any way to pass the credentials along with "Data- From HTML", like i wanted to add "Authorization", ContentType" as headers.

0 Replies