Search results by user ID 16680

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"

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"

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"

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"

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
}

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"

Re: Not all required fields are present

scarson — Mon, 27 Aug 2018 17:11:00 GMT

This worked for me when trying to use insertV2 on the purchaseorder table, but when trying to insert into the purchaseorderline table I keep getting the error message "There was an error in MethodAPIinsertV2".

Here are the fields I'm trying to pass.

fields.append('Item')
fields.append('PurchaseOrderRecordID')
fields.append('Rate')
fields.append('Quantity')
values.append(part.itemID)
values.append(recordID)
values.append(rate)
values.append(part.quantity)

arrNames = [
arrValues = [
arrNames = factory.ArrayOfString(fields)
arrValues = factory.ArrayOfString(values)

Re: Not all required fields are present

scarson — Thu, 16 Aug 2018 18:07:56 GMT

Okay, I don't have any experience with SOAP API's. This is my attempt at using zeep, but I get the same error for the "VendorRef" this time. Do you have an example by chance? Thanks for the help!

d = date.today()
txnDate = str(d.strftime("%m/%d/%y"))

#Get authentication
file = open('config.txt', 'r')
companyAccount = file.readline()
username = file.readline()
password = file.readline()

txnID = '12345'

fields = ['TxnDate', 'TxnID', 'VendorRef', 'Memo']
values = [txnDate, txnID, 'The Stow Company', customer]

client = Client('https://www.methodintegration.com/MethodAPI/service.asmx?WSDL')
response = client.service.MethodAPIInsertV2(**parameters)

print(response)

Not all required fields are present

scarson — Tue, 14 Aug 2018 21:53:43 GMT

I'm trying to make a POST request for MethodAPIInsertV2 to the purchaseorder table. I get a response saying "Not all required fields are present. Required field TxnDate is not passed for the table purchaseorder"

I have included the TxnDate in the passed parameters. Here is my code...

#############################

d = date.today()
txnDate = str(d.strftime("%m/%d/%y"))

#Get authentication
file = open('config.txt', 'r')
companyAccount = file.readline()
username = file.readline()
password = file.readline()

txnID = '12345'

#POST request to method
url = 'http://www.methodintegration.com/MethodAPI/service.asmx/MethodAPIInsertV2'

headers = {'Host': 'www.methodintegration.com', 'Content-Type': 'application/x-www-form-urlencoded'}

parameters = {
'strCompanyAccount': companyAccount,
'strLogin': username,
'strPassword': password,
'strSessionID': '',
'strTable': 'purchaseorder',
'arrInsertFieldsArray': 'TxnDate',
'arrInsertFieldsArray': 'TxnID',
'arrInsertFieldsArray': 'VendorRef_FullName',
'arrInsertFieldsArray': 'Memo',
'arrInsertValueArray': txnDate,
'arrInsertValueArray': txnID,
'arrInsertValueArray': 'The Stow Company',
'arrInsertValueArray': customer
}

r = requests.post(url, headers=headers, data=parameters)
print(r.status_code, r.reason, r.text)

###############################