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
Based on your description, I assume that the step 'Source' returns a record. I created data to reproduce your scenario.
You may add the following step to get the value of 'Key'.
= Record.Field(Source,"Key")
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.