Skip to main content

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!

 

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

 


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. 


@playartsphilly 

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