Required parameter Line is missing in the request - Quickbooks - Error

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
ncollins
Posts: 1
Joined: Thu 15 Mar 2018 14:07

Required parameter Line is missing in the request - Quickbooks - Error

Post by ncollins » Thu 15 Mar 2018 14:15

Hi,

Using the product to Insert a record into the Quickbooks Invoice table and am getting the following error:

"Required parameter Line is missing in the request"

We don't send a Line because we Insert Lines separately to the InvoiceLine table, but I know that the API requires that a line be sent in the Invoice Create call.

How do we form the destination component to work properly to insert a record?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Required parameter Line is missing in the request - Quickbooks - Error

Post by Shalex » Wed 21 Mar 2018 18:59

ncollins wrote: Thu 15 Mar 2018 14:15We don't send a Line because we Insert Lines separately to the InvoiceLine table
InvoiceLineItem is a readonly table. It doesn't allow to insert records into it. InvoiceLineItem is designed to represent data stored in Invoice.Line.
ncollins wrote: Thu 15 Mar 2018 14:15Using the product to Insert a record into the Quickbooks Invoice table and am getting the following error:

"Required parameter Line is missing in the request"

... I know that the API requires that a line be sent in the Invoice Create call.

How do we form the destination component to work properly to insert a record?
You should construct a json value to insert it into Invoice.Line via Devart QuickBooks Destination.

Post Reply