in boomi netsuite connector how to lookup existing...
# ask-stanley-ai
s
in boomi netsuite connector how to lookup existing or new record
c
AI generated answer (using internal Slack threads):
In Boomi, when using the NetSuite connector, you can perform a lookup for an existing or new record by using the 'Get' or 'Upsert' operation respectively. For an existing record, you would use the 'Get' operation. You would need to provide the internal ID or external ID of the record you want to retrieve. For a new record, you would use the 'Upsert' operation. This operation will either update an existing record if a match is found or create a new record if no match is found. You would need to provide the necessary data for the new record in the request. Here is a general example of how you might use these operations: 1. Get Operation:
Copy code
xml
<ns1:get>
  <ns1:baseRef internalId="123" type="customer" xsi:type="ns1:RecordRef"/>
</ns1:get>
In this example, the 'Get' operation is used to retrieve a customer record with an internal ID of 123. 2. Upsert Operation:
Copy code
xml
<ns1:upsert>
  <ns1:record xsi:type="ns1:Customer">
    <ns1:externalId>ABC123</ns1:externalId>
    <ns1:companyName>Test Company</ns1:companyName>
    <!-- Additional fields here -->
  </ns1:record>
</ns1:upsert>
In this example, the 'Upsert' operation is used to either update an existing customer record with an external ID of ABC123 or create a new customer record if no match is found. Remember to replace the 'ns1' namespace prefix with the appropriate namespace for your SOAP request. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.800040364
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.796376
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.795624
Please provide your feedback on this answer.