Data source for Scripted REST API and Robust Import Set Transformer

[denmanty]

Hi,
I have configured a scripted rest api in my instance, where my instance is the consumer.
Endpoint configured on my side and  have this populating an import set table.

Initially I was going to use multiple transform maps but I think using the robust import set transformer will be better as I need to push the data into multiple target tables. From the one rest message being received.

I have configured a data source, type Custom (Load by script) and set the import set table as the import set table I have created. I can also see that robust transformer is linked to the data source.

When I import the data (JSON), I am creating a row on the import set table OK and I can see the robust transform is triggering. 

But for some reason nothing is happening with the data and there are no errors. I am not getting anything into any of the target tables? Has anyone had a similar issue?

Transform history

Data source

[ChrisPurple]

@denmanty did you find a solution for this by any chance? We're having the same problem

[denmanty]

Hi Chris, apologies for the late response.

I ended up just writing directly to the target table from the scripted REST API using GlideRecord secure. Also created a few script includes to handle some mapping or utils type stuff.

This has been working a treat for over a year now.

If you found another solution, please share 🙂

Cheers

Ty