Imported data not getting/updated using transform map

[reddy8055]

Hi, 

I am trying to import the data into "samp_sw_subscription" table. So I have created transform map and data is being imported into the table but record is not getting saved or updated. Whenever we open the record individually which is inserted we are able see the field information but its not displaying from list view. If we save the record then data is visible from list view. I want to see if we can update directly using transform scripts once data is imported ?

Thanks,

[Tony Chatfield1]

Hi, unfortunately your post is not clear regarding your issue or exactly where the data is visible.

If you can see the data in a form view, then the record must exist in the list view for the same table.

Which table can you see the data in 'samp_sw_subscription' or the temporary import table?
If the issue is with 'samp_sw_subscription' have you enabled security debug and checked to see if your data is being hidden from you by an ACL because the data is incorrectly formatted\populated?
Transform scripts run as the data is being populated from the temp import table into the target table IE into 'samp_sw_subscription', yet you post sounds like you are expecting them to run after the record is inserted?

Perhaps you could update this thread to clarify your issue, configuration and requirements so that the community is in a better position to understand and assist.

[reddy8055]

Yes, I see the data in form view but not in list view. Data is imported into samp_sw_subscription table and visible only from form view. see below screenshot.

This is how it is looking from list view where publisher and product fields are showing empty.

[Tony Chatfield1]

Hi, what was the data populated into the record?
Based on the details provided there is a small chance it could be an ACL issue, but I would suspect the reference record sys_id is not valid and so the form shows a 'display name' but there is no correctly mapped underpinning record?
Have you exported XML of the record and validated your references are correct, by searching the reference tables for the sys_id's shown on the record\the sys_id's you posted to the record in your payload?

My recommendation would be to never update a record directly with an API and always use a scripted rest api and or an import\transform map, so that you can validate and align reference records.

[Harish Kota]

Hi @reddy8055 

Please check the Source table and Target table and available fields in the Transform map.

Thanks,

Harish Kota