Method:API Q&A

Re: InsertV2 required field doesnt not exist

Method_Jonathan — Wed, 09 Mar 2016 23:11:28 GMT

The Sales Order table requires the Customer and TxnDate fields - have you supplied these in your original call? If you post up the parameters passed for you original call, I might be able to shed some light as to what caused the error.

The 'Ref' portion is added to the field name in this case because the Customer field is actually referencing the 'Customer' table.

Re: InsertV2 required field doesnt not exist

wayneteng — Wed, 09 Mar 2016 22:15:15 GMT

{ MethodAPIInsertV2Result: '<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Not all required fields are present. Required field CustomerRef is not passed for the table SalesOrder" ></MethodAPI>' }

CustomerRef is not an existing field in SalesOrder.

Re: InsertV2 required field doesnt not exist

Method_Jonathan — Wed, 09 Mar 2016 21:30:22 GMT

Hi Wayneteng,

Can you provide more details to help us identify the problem-

What table are you inserting record into?
Can you post up an example of the parameters you are passing so that we can validate the call?

Thanks

InsertV2 required field doesnt not exist

wayneteng — Wed, 09 Mar 2016 20:10:28 GMT

I used field list and found 2 required fields on my table. When i try to insert passing in those 2 required fields I get a response that says there is a required "CustomerRef" field. This field does not exist in my table. How can I get insert into this table?