Question

SUGAR CRM - Get LABEL values from dropdown, instead ID


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?


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

Userlevel 7
Badge +14

Hi @Enrico 

Good question.

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

 

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?

Userlevel 7
Badge +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

Userlevel 4
Badge +6

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.