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.
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!
You may need to set customfieledlist to be picked up by Stitch
Thanks! It did work: just really needed to dig a bit deeper into the customfieledlist and UNNEST it all
