Comma Delimited Parameter, calling other API

Need help
1

Here’s what we’ve got:

API with the following format : url/IDs=param1,param2,param3…paramN

  • This API returns the values to display in the front end.
  • This is a bulk call.

Repeating group

  • Displays one value in each cell, gets its data from the API above

A second API

  • This API returns the parameters for the first API.

Issue: Haven’t figured out how to properly nest the calls so that it displays values. The second API is working, and I can display the parameter that each cell needs to get its data, but I would like to combine those parameters, make a bulk call, and then put the data in each cell. Of course, it is possible to make one API call for each cell, passing only one of the parameters, but that has been very slow.

How might you go about something like this? Please explain in detail, relatively new user here. Very much appreciated!

2

Can you provide more details about the API Provider you are calling, endpoint and full payload?
Actually, if the API only return a list of ID… you probably have no choice to call each of them in individual call? Or the API Have a “get list” option and you can send the list of ID’s? (At this moment, the RG should show this call, and not the data from url). Maybe you can share some screenshot of your settings?

3

Yeah, I can say a little more. And yes, the API does have a get list option, that’s the whole point. (If you put “https…url/IDs=id_x,id_y” into your browser, you would get a list of two outputs because you put in two ID values.)

The user receives a list of matches for the data they just entered, based on NLP. The endpoint that handles the NLP is the second API, and it has output that looks like this :
[{“ID”: 2867, “Score”: .52},{“ID”: 2867, “Score”: .52},{“ID”: 2867, “Score”: .52},{“ID”: 2867, “Score”: .52},{“ID”: 2867, “Score”: .52}]
Obviously I copied and pasted the same value over and over again, but it returns ten different matches. Those IDs correspond to bigger data items that the first API should access, based on the IDs provided.

I was hoping it was possible to do something like :

  1. get IDs from API
  2. join them together with comma delimiters
  3. tack that joined string as a parameter to the first API

But I don’t know how to do that.

4

Join them using… :join with
Provide this to the API Connector parameters field
If the API Connector 1st call is, for example the one JSON you provided here
It will be each item’s ID:join with , (comma)

5

This topic was automatically closed after 70 days. New replies are no longer allowed.