Troubleshooting NS item group imports from SFDC

[Ethan_Kutch]

I am currently trying to import NS Item Groups from SFDC Product information using a custom flow I'm building.

In NetSuite, Item groups require at least one "component" to create the record. My plan is to use Celigo to always hardcode a NetSuite "dummy item" (int id 974) I have created whenever I create an item group. In this way, I am not setting any component info using SFDC data, strictly from hardcoding the values via Celigo.

However, when I run my flow, I am receiving this error : Failed to save record because Please select member items before submitting.

This error refers to "Member" items which I believe is interchangeable language for Components as I do not see any option to set "Member" items in my available NetSuite fields.

Additionally in my error details request, I can see that the member array has no values, so I believe that for whatever reason my "Components" mapping is not doing the trick.

Any Suggestions?

[tylerlamparter]

This is a bug between preview and runtime. The issue is that you can't hard-code every sublist mapping like you have. You need an array in your input data for at least one of the fields. I would suggest making a transformation step on your export, adding a new field called "items," setting it to an [object] type, and then having a field under it for this hardcoded ID. From there, update your mapping to reference the items array and ID, and it should work fine.

[Ethan_Kutch]

@tylerlamparter

This is a bug between preview and runtime. The issue is that you can't hard-code every sublist mapping like you have. You need an array in your input data for at least one of the fields. I would suggest making a transformation step on your export, adding a new field called "items," setting it to an [object] type, and then having a field under it for this hardcoded ID. From there, update your mapping to reference the items array and ID, and it should work fine.

Thanks Tyler! This makes sense.

However, I am encountering a subsequent error when I add in that transformation.

My Flow is using a delta export type to identify changes made to SFDC products to know when to Add/Update. When I add the transformation, I seem to be losing my start date, I am utilizing the last modified date to use in the delta search.

Here is my Query:

SELECT family, Id, Name, ProductCode, Description,
celigo_sfnsio__NetSuite_Id__c,
celigo_sfnsio__NetSuite_item_type__c,
celigo_sfnsio__Test_Mode_Record__c,
Item_Group_Member__c,
(SELECT Id, UnitPrice, Pricebook2Id FROM PricebookEntries)
FROM Product2
WHERE Family = 'Bundle'
AND Id IN (SELECT Product2Id
FROM PriceBookEntry
WHERE LastModifiedDate >= {{data.lastExportDateTime}}
OR Product2.celigo_sfnsio__Celigo_Last_Modified_Date__c >= {{data.lastExportDateTime}})

Any suggestions?

[tylerlamparter]

Unfortunately, that is also a bug when using Salesforce delta exports and transformation 2.0. For now, swap to transformation script and use this.

function transform (options) {
  
  options.record.items = [{
    id: '123'
  }];
  
  return options.record;
}

[Ethan_Kutch]

@tylerlamparter

function transform (options) {
  
  options.record.items = [{
    id: '123'
  }];
  
  return options.record;
}

That did the trick, thank you so much!

[tylerlamparter]

No problem, sorry for the bugs. I've started some internal discussions to try to get these fixed sooner rather than later.