Formula(text) fields not exporting in saved searches from Netsuite

Ross Orr

• January 18, 2022 19:25

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

• 

  Cory Anderson

  • January 18, 2022 19:27

  

  

  

  

  

  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

  0
• 

  Ross Orr

  • January 18, 2022 19:31

  

  

  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

  

  0
• 

  Ross Orr

  • January 18, 2022 19:53

  

  

  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',' '));

  0
• 

  Cory Anderson

  • January 18, 2022 19:56

  

  

  

  

  

  Ross - try single quotes instead of double. Like this ''. Formulas in NS use singles. 

  1
• 

  Ross Orr

  • January 19, 2022 14:20

  

  

  Thanks Cory, Its always the simple things 

  0

Please sign in to leave a comment.