Method Community

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 ...

We are working on moving our data out of Method:Donor to a new system. We want to use the classic export tool  to export our customers, contacts and donations. But, we need to understand which tables to export and what fields will help us match our donations to the donor who made it. If that is not the best way to do that, ...

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

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.

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 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]

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

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.

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

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 = {   ...