Data source for Scripted REST API and Robust Import Set Transformer

denmanty
Tera Expert

‎03-30-2023 04:23 AM

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

denmanty_0-1680175186500.png

 

Data source

denmanty_1-1680175299321.png

 



0 Helpfuls
  • 1,303 Views
2 REPLIES 2

ChrisPurple
Tera Contributor

‎02-06-2024 01:33 AM

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

0 Helpfuls

denmanty
Tera Expert
In response to ChrisPurple

‎05-19-2024 03:23 AM

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

0 Helpfuls