Schedule transformation from import set table to target table

[ydai]

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

[Tamil5]

Yes Yi Dai, it is extending Import Set Row table.

And yes this transform map created import set properly & works well for LDAP import.

Only it is not working when I use the same transform map for my data import. I mean when I populate data using API

[Stefan Baldhof1]

Hi Yi Dai,

have a look at the "Asynchronous Import Set Transformer" scheduled job. Create a new scheduled job based on this one and modify it to your needs.

Regards,

Stefan

[Tamil5]

Hi Stefan Baldhoff

I just checked the scheduled job, and it is not Active in my instance currently.

Actually what is this job , what change I need to make & how it will help me ?

Am not aware of these...Please advise.

Thanks

Prici

[Manoj Jain1]

Hi Prici,

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

[Manoj Jain1 · Accepted solution]

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