Import data to up to 1000 tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2024 04:13 AM
Hi,
The idea is to import data from Google BQ to approx. 1000 tables in Servicenow. We would like to do it for our customers. What's the best way to perform it? Did someone have similar task?
I am checking solution to do it using App Engine Studio.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2024 06:02 AM
What are you trying through App Engine Studio?
And what is the way you are thinking to solve this? Export and import or an integration? Is it a one time thing, or a continuous thing you need to keep updating?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2024 06:11 AM
Hi Mark,
In AES I created an app with one table, created an action to import data from Google BQ, added to workflow and run it by schedule. Everything works fine besides one thing - there is only one table 🙂 But I need a lot of them, REST step supports only query that equals to import one table. To import many tables have to add many REST steps but there is a limit - 20 steps per action.
I think it should be an integration but any other ideas are welcome. And I need to keep it updating.
