Home

Help Needed: Accessing Custom Field Values in NetSuite using SuiteQL

Hi everyone, I’m currently working on a web development project for a NetSuite client who wants to sync their inventory with Shopify. I have written a middleware application and I am using SuiteQL to query the data from NetSuite to push onto Shopify. So far, everything’s running smoothly except for the item images. The client uses a custom tab in the NetSuite Item edit page to upload these images—each product can have up to 10 images. I need to access the values stored there for each inventory item using SuiteQL.

I’ve attached a screenshot of the custom tab in NetSuite for reference.

Help Needed: Accessing Custom Field Values in NetSuite using SuiteQL

Does anyone have experience with retrieving values from a custom tab in NetSuite using SuiteQL? Specifically, how can I query these custom fields for each inventory item?

Any help or pointers would be greatly appreciated!

Thanks in advance!

Rookie Asked on July 16, 2024 in Best Practices.
Add Comment
Cancel
1 Answer(s)

Hi Amber,

The custom fields should be accessible via SuiteQL like any other field though I’m not sure how the binary data will come through???

Do you have the field IDs for these custom fields? e.g. custitem_***

In any case, a SELECT * should reveal them.

(The one caveat here is that you may be restricted by roile from viewing them.)

Thanks,

Chris

Cancel
Advanced Answered on July 24, 2024.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   SuiteMigration   Become a Sponsor