Skip to main content
Best answer

HubSpot error: Invalid input JSON on line 1, column 40: Cannot deserialize value of type 'long' from String


I am trying to use a Zapier table to reference a specific email based off the extension that answers when a call comes in.

This then is supposed to assign the engagement in Hubspot to that persons email.

I get the data fine from the table part of the Zap, but I get an error when I try to send the data to Hubspot.

Here is where I have the info placed in the Zap:

I have made sure the format matches that of the Assigned to field when the data is to be sent.

Does anyone have any idea what I need to do to get this working?

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @Drakulahn 

These are dropdown fields which have expected values. (e.g. internal IDs)

Follow this help article for guidance: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 

View original
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.

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30901 replies
  • Answer
  • January 23, 2024

Hi @Drakulahn 

These are dropdown fields which have expected values. (e.g. internal IDs)

Follow this help article for guidance: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 


  • Author
  • Beginner
  • 2 replies
  • January 24, 2024

Perfect, this solved exactly what I needed. Thank you!


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6360 replies
  • January 26, 2024

That’s awesome @Drakulahn! A big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗