Schedule transformation from import set table to target table

ydai · ‎03-27-2017

Hi All,

In my scoped application, I have created a table extended from import set row, and one onBefore and one onAfter tranform map script to control the insertion from import set table to the target table. I have an external http client, calling ServiceNow REST API (https://developer.servicenow.com/app.do#!/rest_api_doc?v=helsinki&id=r_TableAPI-GET ) to add record to the import set table, it triggers the transform map scripts immediately, both my import set table and target table shows the record correctly.

Now I don't want the transformation happen immediately when I insert record to import set table. Is there any way I can do it based on schedule or based on number of records I inserted please? For example, once there are 10 new records, start transform or start the transform every 10 minutes.

Thanks,

Yi

Manoj Jain1 · ‎08-25-2017

Hi Yi Dai

Follow following steps for scedule load:

1. Active "Asynchronous Import Set Transformer" job.

2. Change your import set state to loaded from loading.

If you will follow above steps it will work.

For fast result you can change frequency of job from day to second by running it periodically.

Once your test is done set the schedule as per your requirement.

Please Mark as Helpful and correct answer, it it works for you so other can take help from your post.

Best Regards,

MJ

View solution in original post

bernyalvarado · ‎09-29-2017

Hi ydai, do you believe you can mark one of the responses as correct so that we can close this thread?

Thanks,

Berny