Method Community

I'm getting the message: 

There was an error in MethodAPIinsertV2

This message is not much to go on.  Can you guys shed some light?  Account is "mchtechmsp"

Hello scarson,

Can you give us more information as to which Table is throwing this error and what columns are you trying to Insert? It will help us if we can have a look at the request.

The issue is with the purchaseorderline table. I am trying to insert values for Item, PurchaseOrderRecordID, Rate, and Quantity.

Before trying to insert to the purchaseorderline table I have succesfully inserted a Purchase Order to the purchaseorder table.

Here are the parameters for the failing API call.

parameters = {
    'strCompanyAccount': companyAccount,
    'strLogin': username,
    'strPassword': password,
    'strSessionID': '',
    'strTable': 'purchaseorderline',
    'arrInsertFieldsArray': arrNames,
    'arrInsertValueArray': arrValues
}

Hi there,

This endpoint is a soap webservice. Are you using node or python? Are you calling it as just a http post or are you using any soap library?

Regards,

Hossein

yes, I am using the zeep SOAP client for python.

I have successfully inserted purchase orders to the purchaseorder table.

But I get this error when I try to insert purchase order line items to the purchaseorderline table for the previously inserted purchase order.

Are you including the auto generated ID of the Order? Can you please share your field names and values?

I beleive so.

Here are example contents of the arrays. recordID is the value passed back from athe API after adding the Purchase Order.

arrNames = ['Item', 'PurchaseOrderRecordID', 'Rate', 'Quantity']
arrValues = ['100381', recordID, 12.23, 22.00]

I've tried something else and I am now getting this error.

<MethodAPI response = "Not all required fields are present. Required field PurchaseOrderRef is not passed for the table purchaseorderline" ></MethodAPI>

Looking through the tables I can't find a field PurchaseOrderRef for the table purchaseorderline. I've also tried passing this value anyways, but I just keep getting that same error.

Its looking for the RecordID(integer) of the purchase order that this line belongs to.  

A good idea when using the API is to review the tables you are trying to insert into in Method.  The table UI in Method will show you the required fields, what table they come from if relelvant, and the type.

That seems to be part of the issue. "PurchaseOrderRef" is not in the table UI for the purchaseorderline table.

PurchaseOrderRecordID is the field necessary for inserting a PurchaseOrderLine. Looks like your PurchaseOrderRecordID field is not getting inserted to PurchaseOrderLine. Maybe something to do with the way you are trying to insert variables? I see PurchaseOrderRecordID is the only field that has a variable in the above request

I've tried hard coding a previous PurchaseOrderRecordID but the same issue still occurs.

<MethodAPI response = "Not all required fields are present. Required field PurchaseOrderRef is not passed for the table purchaseorderline" ></MethodAPI>

Hello Scarson,

I will reach out to you via email shortly in order to figure this out and get it working.