Formula(text) fields not exporting in saved searches from Netsuite
When exporting a saved search from Netsuite, and columns that are "Formula(Text)" do not export.
They are completely missing from the result, is there a setting I am missing?
0
Comments
They should export with everything else, Ross. Maybe try putting in a Custom Label on those columns in the saved search results. Then you can easily tell which field to map when you bring the results in to .io.
~Cory
Yeah, they all have custom labels, they are predominantly blank (placeholder columns) needed to match a schema thats strict about columns and order.
All of these columns above, should display between the 2 highlighted in the preview below, but they do not, there are other formula(text) fields in this as well, that are not coming over either
So follow up, if the field is completely bkank (no formula or function specified), that is when the columns dont come down to integrator. If I add a "" to the formula field, it at least sends the column down with invalid expression error, and I can just replace the value with "" during the transformation with the snippet below, but its a bit of an irritating work around.
If theres a formula that will populate an empty string instead of null that would be better
Object.keys(options.record).forEach(k => options.record[k] = options.record[k].trim().replace('ERROR: Invalid Expression',' '));Ross - try single quotes instead of double. Like this ''. Formulas in NS use singles.
Thanks Cory, Its always the simple things
Please sign in to leave a comment.