Dataflows asks for credentials for each URL

[Anonymous]

I am trying to implement a API call as a function in a dataflow. The issue is that the URL is created based on different IDs in a column and for each new ID the data flow asks for credentials. Why can't this be set on a higher level of the URL? Any workarounds? 

I fetch the input values from one API to be used in another API call in Business Central. 
regards

Johan

[mahoneypat]

In your Data Source Settings, you should have a pull down to choose the root url instead of each detailed one.

Pat

[Anonymous]

In dataflow there is no option:

It is in Swedish but I guess you get the idea.

[KNP]

I don't do a lot with APIs but this ducumentation looks pretty detailed if you haven't seen it already.

https://docs.microsoft.com/en-us/power-query/handlingauthentication

I'd be surprised if you can't do it at the base level.

[Anonymous]

Great documentation! Thank you. I am a bit unsure whether it can help me (see reply above) but it definitely gave me some ideas on how to proceed.

[KNP]

Can you share your Power Query code (hide anything sensitive obviously), it might help get you an answer.

[Anonymous · Accepted solution]

I did actually solve it after I knew what to search for.
This is the M-code that did require a authentication validation for each combination in the url (I wanted anonymous):

  varApiName = "salesOrders?$expand=salesOrderLines",

  varApiUrl = "https://api.businesscentral.dynamics.com/v2.0/" & TenantName & "/" & Instance & "/api/v2.0/companies(" & Company & ")/" & varApiName ,

  varOptions = [Headers=[ApiKeyName= TokenName , #"Authorization"="Bearer " & List.First(GetToken), #"DataAccessIntent" = "ReadOnly" ]],

  apidata = Json.Document(Web.Contents(varApiUrl , varOptions)),

and this is the solution that prevented it:

  varApiName = "salesOrders?$expand=salesOrderLines",

  varApiUrl = "https://api.businesscentral.dynamics.com/v2.0/" & TenantName & "/" & Instance & "/api/v2.0/companies(" & Company & ")/",

  varOptions = [RelativePath=varApiName, Headers=[ApiKeyName= TokenName , #"Authorization"="Bearer " & List.First(GetToken), #"DataAccessIntent" = "ReadOnly" ]],

  apidata = Json.Document(Web.Contents(varApiUrl , varOptions)),

The changes are in bold.