I am getting error:
get operation on customer record was not successful
error
type: ERROR
code: INVALID_KEY_OR_REF
message: Invalid location reference key undefined.
When performing an upsert on a Sales Order record. Checking the integration log shows that the customer is being retrieved correctly which makes the error misleading.
My SOAP request looks correct and is as follows:
soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Body> <upsert xmlns="urn:messages_2012_2.platform.webservices.netsuite.com"> <record xsi:type="ns1:SalesOrder" externalId="extID134817410243" xmlns:ns1="urn:sales_2012_2.transactions.webservices.netsuite.com"> <ns1:customForm xsi:type="ns2:RecordRef" internalId="222" xmlns:ns2="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:entity xsi:type="ns3:RecordRef" type="customer" internalId="1221212123" xmlns:ns3="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:tranDate xsi:type="xsd:dateTime">2012-11-10T05:00:00.000Z</ns1:tranDate> <ns1:orderStatus xsi:type="ns4:SalesOrderOrderStatus" xmlns:ns4="urn:types.sales_2012_2.transactions.webservices.netsuite.com">_pendingFulfillment</ns1:orderStatus> <ns1:otherRefNum xsi:type="xsd:string">ourPOnum</ns1:otherRefNum> <ns1:memo xsi:type="xsd:string">Order</ns1:memo> <ns1:shippingTaxCode xsi:type="ns5:RecordRef" type="taxGroup" internalId="16" xmlns:ns5="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:class xsi:type="ns6:RecordRef" internalId="2" xmlns:ns6="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:itemList xsi:type="ns1:SalesOrderItemList" replaceAll="false"> <ns1:item xsi:type="ns1:SalesOrderItem"> <ns1:item xsi:type="ns7:RecordRef" internalId="1111" xmlns:ns7="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:quantity xsi:type="xsd:double">1.0</ns1:quantity> <ns1:price xsi:type="ns8:RecordRef" type="priceLevel" internalId="-1" xmlns:ns8="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:amount xsi:type="xsd:double">44.97</ns1:amount> <ns1:location xsi:type="ns9:RecordRef" type="location" internalId="7" xmlns:ns9="urn:core_2012_2.platform.webservices.netsuite.com"/> <ns1:customFieldList xsi:type="ns10:CustomFieldList" xmlns:ns10="urn:core_2012_2.platform.webservices.netsuite.com"> <ns10:customField xsi:type="ns10:StringCustomFieldRef" internalId="custcol_amazon_line_id"> <ns10:value xsi:type="xsd:string">ourCustField</ns10:value> </ns10:customField> <ns10:customField xsi:type="ns10:StringCustomFieldRef" internalId="custcol_onlinedisplayname"> <ns10:value xsi:type="xsd:string">skuName</ns10:value> </ns10:customField> </ns1:customFieldList> </ns1:item> </ns1:itemList> </record> </upsert> </soapenv:Body> </soapenv:Envelope>
but my response states: <soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header> <platformMsgs:documentInfo xmlns:platformMsgs="urn:messages_2012_2.platform.webservices.netsuite.com"> <platformMsgs:nsId>WEBSERVICES_asdasdas_asdasdasdasdasdas795953_9e8e71bf825d249</platformMsgs:nsId> </platformMsgs:documentInfo> </soapenv:Header> <soapenv:Body> <upsertResponse xmlns="urn:messages_2012_2.platform.webservices.netsuite.com"> <writeResponse> <platformCore:status isSuccess="false" xmlns:platformCore="urn:core_2012_2.platform.webservices.netsuite.com"> <platformCore:statusDetail type="ERROR"> <platformCore:code>INVALID_KEY_OR_REF</platformCore:code> <platformCore:message>Invalid location reference key undefined.</platformCore:message> </platformCore:statusDetail> <platformCore:statusDetail type="WARN"> <platformCore:code>WARNING</platformCore:code> <platformCore:message>ourSku: You have only 0 available at this location (0 back ordered, 19202 on order).</platformCore:message> </platformCore:statusDetail> </platformCore:status> <baseRef xsi:type="platformCore:RecordRef" type="salesOrder" externalId="extID1349716" xmlns:platformCore="urn:core_2012_2.platform.webservices.netsuite.com"/> </writeResponse> </upsertResponse> </soapenv:Body> </soapenv:Envelope>
Please note that the externalID's and various values have been altered to protect the identities of the innocent. Also note that I have treat warnings as errors set to false. Any ideas on what I'm missing?