Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a first query (API call: POST https://api.intercom.io/conversations) that return:
id_of_conversation - ....
Then I would like to do a second query: API call: POST https://api.intercom.io/conversations/{id_of_conversation}
How can I do to do a query that uses the list returned by the previous query?
I have created a list with all id_of_conversation. Then I tried to create a new source but it fails:
let
Source = Json.Document(Web.Contents("https://api.intercom.io/conversations/" & conv_id_param, [Headers=[Accept="application/json", Authorization="Bearer xxxxxxxxx="]]))
in
Source
I receive this error message: "Formula.Firewall: Query '22394727443' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
Thanks for your help
Best Regards,
Paul
Solved! Go to Solution.
Hi @Anonymous
It seems you want to return some rows/columns from API call: POST https://api.intercom.io/conversations,
This is filtered by selected id_of_conversation.
For example, there are many id_of_conversation(1,2,3) in the API call https://api.intercom.io/conversations,, but you want to return all rows where id_of_conversation=1.
or you want to return only one column "id_of_conversation".
If so, you could create query parameter, then use it in connection string in Advanced editor.
Power BI Desktop Query Parameters, Part 1
Parameters for JSON API data - Maintain Query daily
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
It seems you want to return some rows/columns from API call: POST https://api.intercom.io/conversations,
This is filtered by selected id_of_conversation.
For example, there are many id_of_conversation(1,2,3) in the API call https://api.intercom.io/conversations,, but you want to return all rows where id_of_conversation=1.
or you want to return only one column "id_of_conversation".
If so, you could create query parameter, then use it in connection string in Advanced editor.
Power BI Desktop Query Parameters, Part 1
Parameters for JSON API data - Maintain Query daily
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
61 | |
40 | |
37 | |
28 | |
16 |