Linked Data Fields - Two API sources

[michael48]

I have two API sources that each provide me with partial data that I’m wanting to display on the front end of my app.

API Source 1 gives me:
Property ID
Agent ID
Agent Name
Price

API Source 2 gives me:
Agent ID
Agent Name
Agent Phone Number
Agent Email.

Agent ID matches on both and should be linked together.
Agent Name matches on both and should be linked together.

I am manually refreshing both APIs each day but I cannot figure out how to keep the data linked together while they are continuously updating.

Any guidance here is greatly appreciated!

[animisha45]

Hi @michael48

Could you give a bit more details?
Are they being used to display in repeating group? Or do you want to add them in the same data type in database? What do you mean by link together?

All of these are possible. A bit more detail would help in guiding in correct way.

[michael48]

@animisha45
I have the data currently showing in a RG but with a long string of “do a search for” with filters, constraints, etc. It works but it’s a mess.

Figured it’ll be a lot cleaner to make the data fields reference each other (linked) in the database so that’s what I’m hoping to do.

Hopefully that helps clarify.

[hanan1]

I’m not sure how the API calls are triggered on user side in your app, but one way to connect them would be to use the agent ID from first API call as parameter for second API call, that way you manually refresh the first API and that refreshes the second.