Forum Discussion

rpiboy_1's avatar
rpiboy_1
Helper V
3 years ago

Web.Contents dynamically passing a record

Hi all, I'm attempting to write a funtion that dynamically builds the entire Web.Contents query for a REST API endpoint. Right now I have it broken into two funtions. An inner function that builds th...
Need Help
ams1's avatar
ams1
Responsive Resident
3 years ago

Hi rpiboy_1 

 

As Query needs to be a record, you need to place something (a string) in the QueryString column that can be easily converted into a record.

 

One option is to place a json string inside - ex. {"show_all":"1"} - and then inside PowerQuery you can do:


=Table.AddColumn( ... Json.FromValue([QueryString]))

Not at the PC to test the above "conversion from json string to record" - maybe it's Json.Document(Text.ToBinary... 😉

 

 

 

Please mark this as answer if it helped.

rpiboy_1's avatar
rpiboy_1
Helper V
3 years ago

ams1 I understand what you're proposing, but I would think that there has to be a way to grab the 'record' that is there in the column...? The JSON suggestion is intriguing as it may open up some other possibilities. Will have to think about it and do some testing.

Interested to see if anyone else has any other suggestions or thoughts?