Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

API call for each row - 400 Bad Request

I have a list of parent ID's generated from an intial API call: Now I want to call a second API for each row, using each of these parent ID's as inputs, and put it all into one big table. So I...
Need Help
  • freginier's avatar
    freginier
    3 years ago

    To collect detail data from API you need to create 

    - Query One with all records (filter only on one for your test)

    - Query Two with detail for one record 

    - Parameter to send ID to second query 

    - Create a function Query Two + Parameter 

    - Use custom function in Query one to get detail for all ID

     

    Did you do all these steps ? 

     

    ______________________________________________________

    If you found this post helpful, please give Kudos C

freginier's avatar
freginier
Solution Sage
3 years ago

To collect detail data from API you need to create 

- Query One with all records (filter only on one for your test)

- Query Two with detail for one record 

- Parameter to send ID to second query 

- Create a function Query Two + Parameter 

- Use custom function in Query one to get detail for all ID

 

Did you do all these steps ? 

 

______________________________________________________

If you found this post helpful, please give Kudos C

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This ordering of steps is what I needed. I have it working now. Thank you!