Export data from NetSuite

Comments

9 comments

  • Integration User

    I need some help on this. Would like to setup an export using a the export functionality and using the existing sandard flow rather than have to create another flow and recreate the mapping. Please reach out to me at alaa.alkhafaji@sparsolutions.com

    0
  • Driven Products

    Great walkthrough, thank you. One question. I am exporting a CSV from saved search results and uploading to FTP. For several of the fields exported from NetSuite, there are quotes added around the field values. How can I remove these quotes from the finalized export file?

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Driven Products,

    There is a checkbox "Wrap with quotes" on the FTP import setting page. Can you check whether you accidentally checked this? It's not checked by default. If that doesn't solve your problem, please provide more context or submit a support ticket. Thanks!

    1
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Integration User,

    It's not clear what you're trying to do here? Can you provide more context or submit a support ticket? Thanks!

    0
  • Stephen Lemp

    In the context of a NetSuite Saved Search, when I select "Group Rows", am I guaranteed that all rows from the Saved Search will be included in that group, or is it possible that the lines will be broken out into batches?

    0
  • Stephen Brandt Documentation Manager Community moderator
    Engaged
    Great Answer
    Top Contributor
    Celigo University Level 3: Master

    Hi, Stephen Lemp. Great question. 

    Group rows will indeed guarantee that all lines in a single order are grouped together.

    Before enabling row grouping, make sure that your saved search is sorted by Internal id.

    0
  • Christoffer Sinnbeck
    Engaged

    Hi,

    Can anyone tell me what the "Cancel" execution type means, and in which situation(s) it is triggered? Thanks!

    0
  • Nithin Gollapally QA Lead
    Celigo University Level 4: Legendary

    Hi Christoffer,

    Execution Type : Cancel is used to sync the records when the record is getting updated with Cancel action.

    Ex : If we want to sync the NetSuite Salesorder cancel status to any other application , we can use Cancel execution type.

    If the Cancel action is performed via User Interface context the flow will get triggered, if the cancel status of the record is being with UserEvent context, it will not trigger the flow as UserEvent will not trigger Celigo UserEvent to trigger the flow.

    Thank you

    0
  • Christoffer Sinnbeck
    Engaged

    Nithin Gollapally Thank you!

    0

Please sign in to leave a comment.