Method Community

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?

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?

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

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.