Hi,I have a zap when a bill is created in QuickBooks a copy of the details is put into a GoogleSheet. It captures Supplier Name Invoice number Date of Invoice Amount Project (via the customer field) - if there is more than 1 project (different line items) then I split the field to only take the first project value. I do this via Python code by zapier.My issue is when no Project is indicated the zap fails as there is no value. I get the issue File "<string>", line 8, in the_function KeyError: 'ProjectQBO' How do I get around this? I do not want to filter the zap as I still need the data to be sent but with nothing in the Project field

Question

QuickBooks to Google Sheets - no value in a field for python code to work

Userlevel 1

Hi,

I have a zap when a bill is created in QuickBooks a copy of the details is put into a GoogleSheet. It captures

Supplier Name
Invoice number
Date of Invoice
Amount
Project (via the customer field) - if there is more than 1 project (different line items) then I split the field to only take the first project value. I do this via Python code by zapier.

My issue is when no Project is indicated the zap fails as there is no value. I get the issue

File "<string>", line 8, in the_function KeyError: 'ProjectQBO'

How do I get around this? I do not want to filter the zap as I still need the data to be sent but with nothing in the Project field

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.