Basic Question = How to pass value to a variable

[Tommy____G]

Hi,

This is going to be so simple to somebody but I don't know where to start and I've tried searching the forum but getting myself even more confused.

I have to connect to a system that publishes a dynamic API key every 24 hours.  I can do these two steps manually but just can't combine them.

let

GetAPIKey = Json.Document(Web.Contents("http://SomeSystemPath/Auth?UserName=MyUserName&Password=MyPassword")),

'The above returns the API Key but how do I pass it to the following bits 

Source = Json.Document(Web.Contents("https:////SomeSystemPath/Levels?WarehouseId=3&APIKey=GetAPIkey")),

in Source

Any helpwould be greatly appreciated...

Thanks

Tom

[mahoneypat · Accepted solution]

Please try this instead.

let

GetAPIKey = Json.Document(Web.Contents("http://SomeSystemPath/Auth?UserName=MyUserName&Password=MyPassword")),

Source = Json.Document(Web.Contents("https:////SomeSystemPath/Levels?WarehouseId=3&APIKey=" & GetAPIkey))

in Source

Pat