CODEWITHSUNDEEP
soapnetsuitesuitetalk
el n00b
el n00b

Reputation: 1863

NetSuite and SuiteTalk list all of a type (paged or not)

I am currently trying to work with the SuiteTalk 2017_2_0 API for a new integration with NetSuite. I have all the basics rolling of single record retrieval, etc.; however, I am having a problem trying to figure out how to list all of a given object/type in the system.

Example: I want to list ALL InventoryItem data.

Not sure what I am missing. Does anyone have a sample SOAP doc?

What I did so far

I have been working primarily with types: Sales Order, Customer and Inventory Item.

  1. Tried using the getAll call defined in the WSDL - only supports limited fields:

    • budgetCategory
    • campaign*
    • currency
    • etc.

  2. Tried using getList but a set of internal IDs are required in the baseRef/RecordRef (INVALID_KEY_OR_REF - The specified key is invalid.)

Fails:

<urn:getList>
  <urn1:baseRef xsi:type="core:RecordRef" type="salesOrder" />
</urn:getList>

Succeeds:

<urn:getList>
  <urn1:baseRef xsi:type="core:RecordRef" type="salesOrder" internalId="1" />
  <urn1:baseRef xsi:type="core:RecordRef" type="salesOrder" internalId="2" />
</urn:getList>
  1. Tried formulating a search that would return all the data but the types I need are unavailable (or I haven't been able to figure it out)

Upvotes: 0

Views: 1322

Answers (1)

Suite Resources
Suite Resources

Reputation: 1164

Define a saved search that pulls the appropriate data, then call the saved search.

Upvotes: 1

Related Questions