Show 1 value in interface but save another in DB from an API call

HI all,

I’m pulling a list of ‘contacts’ from an API and displayed dynamically in a dropdown. I want my users to see the ‘Contacts Name’ but i would like to save the ‘Contacts ID’ in the DB.

When I go to save in DB all I can do is save ‘Value’ from dropdown which = Contacts Name. How can I fix this or solve it?

Thanks

Can you share you DD setting?
You probably go too deep in the API response and should probably stop at a previous level.

Can you also share the API Call result in API Connector?

Yup see this video: Loom | Free Screen & Video Recording Software

Instead of display the names directly in a dropdown, create a repeating group with the data. Make it invisible. Use this repeating group as the source of your dropdown’s values.

So when you wish to save the name, it will be easy to locate the ID as well (or any other field)…

Thanks! That helped but still have a snag.

So the Repeating Group idea worked. But what is happening now is that my API is saving all the Customer ID’s as a list. I don’t actually want this I only want the corresponding ID that the User has selected from their drop down. Any ideas?

Screen Shot 2021-07-25 at 6.16.48 PM