Forum Discussion
Convert a value of type Record to type Text
In case it helps, FYI that I just put out a video on using REST APIs with power query. It shows how to get the count and use it to create a list of numbers to make multiple calls with $skip or offset to get all the data (so don't have to worry about pagination).
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
Community ChampionHi Anonymous ,
I'm having problems understanding your problem description.
But I can see what's probably causing trouble:
You're using the "URL"-step/variable in the "GetJson"-function in the "Raw data"-step.
For it to work there, it has to be in text format.
But the value you're assigning this variable with ("BaseURL") is most likely a record.
That would explain the error message.
So what you would have to do there is to parse out the actual URL string before assigning it to the variable "URL".
ImkeF could you please advice in how can I parse the URL to converte it from record to list?
Thank you in advance