IntegrationHub ETL and DataSource from REST API

[anwie]

Hello together,

I am just trying out the possibilities with IntegrationHub ETL, because we want to fill the CMDB for our customer from different sources. And this relative new functionality seems nice.

As I understand, the source for an ETL Transform Map is a data source. My first steps for learning I have done with uploaded files (used the course in LeaningNow).

So now to my question: is the following scenario possible?

1. 3rd party sends data per scripted REST API into a defined table
2. this table should be the data source for an ETL Transform Map, which runs everey time, when new data is send per REST

But as data source I did not find a suitable option. So the scenario is not realizable? Or is there another way that we could use both scripted API in combination with IntegrationHub ETL?

Hope I could describe the situation understandable.

Thanks and kind regards,
anwie

[craigschotke]

Hi Anwie, we are in a similar situation. Did you ever find a solution for this? 

[Randy Fisher]

I was able to get this working with some help from our partner.  Essentially, we started with a excel export of the data from the third party tool and built the data source as an excel import.  We ran the import from the spreadsheet to build the import set tables and then updated the data source to json.  We then setup the ETL to use that data source and had the vendor send the CI data to 

https://instance-name.service-now.com/api/now/cmdb/ingest/data_source_sys_id 

ETL then took over and did the transform.  Is that what you were looking for?  Let me know and I can maybe answer more.  Thanks

[craigschotke]

Hi Randy, that sounds like exactly what we need. Thanks for the quick reply.

[anwie]

Hello Randy,

thank you for the reply and the description of your solution. Meanwhile we have done the integration the "old" way with Transform Maps.

But I will try your solution at the next opportunity on my personal instance.

Kind regards,
anwie