Skip to main content
Best answer

Google Sheets - Kashflow Invoice - "InvalidParameters"


Forum|alt.badge.img

Getting an error when trying to create new invoices on KashFlow, taking the data from a Google Sheet.

Worked fine when tested the Zap.

 

Here is the Data In, which appears correct to me:

 

searchBy:

Code

TradeBorderType:

Domestic

createCustomer:

False

UpdateCustomerAddress:

False

UseCustomDeliveryAddress:

False

UpdateCustomerDeliveryAddress:

False

CreateProduct:

False

Quantity:

1

Rate:

251

VATIncluded:

False

VATExempt:

False

AdditionalVATIncluded:

False

ShippingDescription:

Additional Charge

DiscountDescription:

Discount

CustomerName:

Liverpool Shop Safe/Floats

CustomerCode:

LIVE01

Email:

placeholder@email.com

IssuedDate:

18/03/2024

DueDate:

18/03/2024

Currency:

GBP

NominalCode:

100

Description:

Cash Sales 18/12/2024

VATLevel:

0

VATAmount:

0

Amount:

251

Method:

2250250

AccountId:

803383

Date:

18/03/2024
AdditionalCharges:

0:

AdditionalVATIncluded:

False

ShippingDescription:

Additional Charge
LineItems:

0:

CreateProduct:

False

Quantity:

1

Rate:

251

VATIncluded:

False

VATExempt:

False

NominalCode:

100

Description:

Cash Sales 18/12/2024

VATLevel:

0

VATAmount:

0
InvoiceLevelDiscount:

0:

DiscountDescription:

Discount
DeliveryAddress:

0:

UseCustomDeliveryAddress:

False

UpdateCustomerDeliveryAddress:

False
CustomerBillingAddress:

0:

UpdateCustomerAddress:

False
InvoiceComments:

0:

 
CustomerDetails:

0:

searchBy:

Code

TradeBorderType:

Domestic

createCustomer:

False

CustomerName:

Liverpool Shop Safe/Floats

CustomerCode:

LIVE01

Email:

XXXXXXX@XXXXXXXXXX.co.uk
PaymentLines:

0:

Amount:

251

Method:

2250250

AccountId:

803383

Date:

18/03/2024

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Best answer by harryw4444

Looks like I’ve solved the issue. Kashflow API documentation on this page suggests that the date formatting needs to be in YYYY-MM-DD HH:mm:ss Z, so I’ve set the date/time formatter step to this format and it appears to be working. 

 

 

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

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@harryw4444 

For us to have full info, post these screenshots:

  • the encountered error on the Zap step
  • how your Zap step is configured in EDIT mode with the fields and field mappings visible

Forum|alt.badge.img
  • Author
  • New
  • 2 replies
  • February 13, 2025

 

 

I believe the issue is something to with the date formatting. I’ve added a date/time formatter step, and tried a few different formats for the date without any luck. I’m wondering if Kashflow requires a very specific formatting of this date, or whether there’s another issue.


Forum|alt.badge.img
  • Author
  • New
  • 2 replies
  • Answer
  • February 13, 2025

Looks like I’ve solved the issue. Kashflow API documentation on this page suggests that the date formatting needs to be in YYYY-MM-DD HH:mm:ss Z, so I’ve set the date/time formatter step to this format and it appears to be working.