- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2022 02:34 PM
Good afternoon, everyone,
Has anyone integrated CDW with SNOW?
The context of this question is that anytime my company buys hardware from CDW, a file is generated with serial numbers and asset tags (along with other details) of all of the items being shipped to us. Per CDW's documentation, at least from what I found, we're using an API to post the data from CDW into a custom table that I built out. On that end, everything is working fine. Every item that we buy from CDW, it is posted to the custom table with all of the information of that item. My ultimate goal is that when something is inserted into the custom table and it has an asset tag, it will automatically create the asset on the hardware asset table and remove the manual process of creating the asset.
Is this possible? If so, could someone give me a little guidance or best practices on how to accomplish this?
I have attached the documentation from CDW of all the information that CDW posts to the custom table but I want to move anything with an asset tag from the custom table to the hardware assets table.
Best regards,
Corey
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2022 06:15 PM
Corey you could just create another transform and run them both on the original import table. That way you have all the functionality of import sets / transforms and don't have out all the logic in a business rule.
If you need to 'filter' the records, you can have those checked in the onBefore or onStart script (whichever runs for each record; I can't remember which one it is).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-22-2022 09:11 AM
Hi Corey,
Were you able to complete this integration? We are trying to integrate all the assets shipped from CDW to Asset table. But facing issues with the mapping. How are you mapping the fields? The
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-22-2022 11:47 AM - edited 12-22-2022 11:52 AM
See original post
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2022 04:00 AM
Hi Corey,
We do have a staging table where all the CDW data got inserted. But, the major issue we are facing is in terms of Model. Models in ServiceNow and the data coming from CDW is different. We can't even map the model in CDW vs SNOW. That's the issue we are facing now.
- Can we somehow customize CDW API to use Servicenow models while triggering API?
- The description from CDW is very generic and we can't use Manufacturer, Model Category,Name fields to fetch models while creating the asset.
What else could be the ways to overcome the issue
