Skip to main content
Question

SUGAR CRM - Get LABEL values from dropdown, instead ID


Enrico

Hello everyone, I want to connect SUGAR CRM 7+ with GETRESPONSE, all is ok, but when I try to match the fields from SUGAR I have some field in dropdown and I see that Zapier take the ID value of the SugarCRM dropdown and not the LABEL value of the dropdown. Is possibile take the LABEL value of the dropdown instead the ID value?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Enrico 

Good question.

You may have to create lookup tables to translate the IDs to the desired values.

 


Enrico
  • Author
  • Beginner
  • 1 reply
  • March 10, 2023

Thank you! In fact, I too had thought of using this system but the problem is that the mapping of the values ​​is static and if the dropdown values ​​change over time in the CRM I should remember to update the mapping in the lookup table. It would be nice if it was possible, when importing data from a dropdown from SugarCRM, to choose whether to import the ID or the VALUE from the dropdown.

Is there any way to do this?


Troy Tessalone
Forum|alt.badge.img+14

@Enrico

If there is, you’d need to explore using the Sugar CRM API: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.0/Integration/Web_Services/REST_API/

App APIs can be used in Zaps with the Webhooks app: https://zapier.com/apps/webhook/help


Brem
Forum|alt.badge.img+6
  • Zapier Staff
  • 404 replies
  • March 15, 2023

Hi @Enrico 

I noticed that you contacted our Support team and one of our Support Specialists recommended what Troy suggested (using a lookup table).

If you’re still having problems, i suggest continuing the conversation with our Support Specialists.