Hello,
I need to get a confirmation that this is the best plan for an integration between Servicenow and Microsoft Project Online
So the requirement is I need to do a first full load of all the projects inside the company's Microsoft Project Online tool to Servicenow and after that, once a day I'll need to update the projects with whatever updates the Microsoft Project Online has had.
My Initial thoughts are:
1. Setting up the Rest Messages to get the info
2. Creating an Import Set
3. Creating a transform map with the scripts to adjust the payload values to the proper format of the [pm_project] fields
4. Creating a scheduled job to run once a day invoking the REST call
Question, is that the best option to approach this?
And with coalescing the PROJECT ID (ID ON MICROSOFT PROJECT) will I be able to simply update information without to having to erasing all the prjs and inserting again (delta)?
Thanks,
Vini
