Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

OBTAINING DATA THROUGH API

Good morning community, I wanted to make the following query of how to obtain data when connecting to a database via API.

I need to get the detail of suppliers from a database, for this I have a table where it brings me all the suppliers, I attach the print.

Then via another API I get the detail of each of those providers, but the drawback is that the api connects provider by provider, that is, the query is based on the provider code, and not general.

Is there any way that in the data of "Supplier Code" (to consult the detail), it is a variable that searches row by row the code of the supplier and so the query is made repeatedly to obtain the detail of all the suppliers?

I appreciate any help!!

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Make your first call to list all suppliers. Then use the "Add custom Column"  function to make another call for that specific supplier. This will then run for every row (ie every supplier).  Lastly, decide how to concatenate the results.