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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi freginier, one followup question. The parameter requires me to enter a single "current value", but this causes my visuals on the reporting side to be filtered by that single value which is undesirable. How to I prevent this?

 

freginier's avatar
freginier
Solution Sage
3 years ago

don't worry about this value it's only for first run. When you will create a function based on your parameter the value with change automaticaly