Forum Discussion
Extract specific value from JSON file and put it in a variable
Dear M query king and queens, I made a custom function that retrieves an API Acces key so i can retrieve data from an API. The code is as following: (UserName as text, OfficeCode as text, ...
Hi dvdbroek
In your code you'll have a step that calls that function and results in the single row table, something like this
GetAPIKey = Call_API_Key_Function(.......)
giving a table like this
To get the Key use a line like this, where GetAPIKey is the name of the step that calls the function and results n the table - change this as appropriate to suit your code.
KeyFromAPI = GetAPIKey[Key]{0}
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.