Method:API Q&A

Re: API error message "There was an error in MethodAPIinsertV2"

Laks_Method — Tue, 04 Dec 2018 15:40:10 GMT

Hello Scarson,

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

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Tue, 04 Dec 2018 04:19:21 GMT

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

Re: API error message "There was an error in MethodAPIinsertV2"

Laks_Method — Mon, 29 Oct 2018 15:06:48 GMT

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

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Fri, 26 Oct 2018 17:56:18 GMT

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

Re: API error message "There was an error in MethodAPIinsertV2"

v.cameron — Fri, 26 Oct 2018 17:43:45 GMT

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.

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Fri, 26 Oct 2018 17:27:10 GMT

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

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.

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Fri, 26 Oct 2018 01:09:56 GMT

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]

Re: API error message "There was an error in MethodAPIinsertV2"

Method_Hossein — Thu, 25 Oct 2018 19:03:21 GMT

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

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Thu, 25 Oct 2018 16:23:20 GMT

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.

Re: API error message "There was an error in MethodAPIinsertV2"

Method_Hossein — Thu, 25 Oct 2018 16:00:41 GMT

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

Re: API error message "There was an error in MethodAPIinsertV2"

scarson — Thu, 25 Oct 2018 15:53:26 GMT

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
}

Re: API error message "There was an error in MethodAPIinsertV2"

Laks_Method — Thu, 25 Oct 2018 13:09:35 GMT

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.

API error message "There was an error in MethodAPIinsertV2"

scarson — Wed, 24 Oct 2018 21:32:05 GMT

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"