Skip to main content
Question

SUGAR CRM - Get LABEL values from dropdown, instead ID

  • March 9, 2023
  • 4 replies
  • 145 views

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?

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 9, 2023

Hi @Enrico 

Good question.

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

 


Enrico
  • Author
  • Beginner
  • 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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 10, 2023

@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
  • 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.