How to filter out existing records?


1 comment

    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer

    Hello Nick Rutsky
    This is Khaisar from Celigo Engineering team. 
    Can we get more details on the flow. What is the import API on Square. Is it "Catalog's" API, which you will using.
    As per the details, I suppose you are exporting the Item records from NetSuite and creating individual items (including variants) in Square. 
    If this is the case, then what is the identifier field using which you want to identify the existing items in Square. Generally other users have their unique SKU added to the field "Item Name / Number" on the item record in NetSuite. Similarly do you have any field which holds that unique identifier of each item. If you have such field, then we can make use of the same field rather adding a new custom field. 
    Please review this and let us know for any further questions. 


Please sign in to leave a comment.