Skip to main content
Best answer

Insightly error: The app returned "This value must be a number between 9223372036854775808 and 9223372036854775807"


I am building a new Zap connect a JotForm submission to Insightly. I successfully made the connection and tested the Zap which worked for creating a contact but when I try to create a project, its returning an error: 

 

Failed to create a record in Insightly

The app returned "This value must be a number between -9223372036854775808 and 9223372036854775807".

 

Anyone here have experience with Insightly?

Best answer by Sully

Just so the community knows the issue… When I was trying to populate a specific Lookup fields tied to Organizations, I needed to create a lookup step to get the organizations ID number so it would populate the organization correctly.

View original
Did this topic help you find an answer to your question?

Troy Tessalone
Forum|alt.badge.img+14

Hi @Sully 

One of the fields expects a number.

To give us full context, post screenshots with how the steps are outlined and configured in EDIT mode, so we can see field types and field descriptions.


  • New
  • March 20, 2024

I think I just figured it out. I think one of the field values dont match formatting in Insightly and i will need to test them one by one to find the issue.

 

Thanks for your help!


  • New
  • March 20, 2024

Just so the community knows the issue… When I was trying to populate a specific Lookup fields tied to Organizations, I needed to create a lookup step to get the organizations ID number so it would populate the organization correctly.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • March 21, 2024

That's fantastic news, @Sully! We're thrilled to hear that you were able to find a solution to the issue here.

Additionally, we want to extend our gratitude for sharing the solution with our Community members. This information will be beneficial to those who may encounter similar issues in the future.


Did this topic help you find an answer to your question?

Reply