RE: Stitch integration or a general question about custom columns

Hey community! A question about Stitch integration: has anyone used this with NetSuite and did anyone else run into an issue when Stitch doesn’t pick up custom columns from the “transaction” table?  Is there a way to overcome it or it could be some permission issue?
We have a standard API in parallel to Stitch, and that integration picks up any custom object we need based on a saved search results.

KseniiaPtitcyna Rookie Asked on November 15, 2022 in SuiteTalk.
Add Comment
3 Answers

Column custom fields are held as key value pairs in their own table. Eg

Transaction__itemList__item__customFieldList

you have to join that table to the sublist and the transaction, then filter on name to get the results.

it’s fiddly!

Rookie Answered on November 15, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.