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.

Rookie Asked on November 15, 2022 in SuiteTalk.
Add Comment
3 Answer(s)

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


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

You may need to set customfieledlist to be picked up by Stitch

Rookie Answered on November 15, 2022.
Add Comment

Thanks! It did work: just really needed to dig a bit deeper into the customfieledlist and UNNEST it all

Rookie Answered on November 16, 2022.
Add Comment

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   Limebox   Become a Sponsor   Become a Sponsor