Skip to main content
Question

Jotform submission to QBO invoice using code step "Invalid Reference ID" error

  • July 18, 2025
  • 3 replies
  • 11 views

I’m trying to create a zap that creates an invoice in QBO from a jotform submission trigger. (I can’t use the innate jotform “create invoice” function due to some limitations.)

 

After the trigger I’m using a code step to parse out all the necessary information, then trying to feed it into the “create invoice” step, but I keep getting an “invalid reference ID” error. This is how I have the java step set up: 

 


And this is an example of my output: 


But when I then feed that into the create invoice step:

 

I get that ^ error. 

I tried adding a “find products (with line item support” step, but it will only return the first product, not multiples. 

Full disclosure: I’m getting the code from ChatGPT because I’m not a coder, so I’m quite sure that’s where some of my issues are coming from, lol. I’ve gone round and round trying to troubleshoot it and haven’t gotten anywhere so i thought I’d try here. 

Thanks in advance for any help you can give me!

 

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34070 replies
  • July 18, 2025

Hi ​@playartsphilly 

Error is related to this QBO Invoice field: Product/Service

Field expects the QBO ID(s) of the Product/Service, rather than the names.

Help links for understanding expected values for dropdown fields: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

 

You need to add this Zap step: QBO - Find Products

 


  • Author
  • Beginner
  • 5 replies
  • July 18, 2025

Thanks, so I already tried the find products step, but it will only return the first product in the list, not each one as a line item. 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34070 replies
  • July 18, 2025

@playartsphilly 

Make sure to adjust the setting for the field: If multiple search results are found