Comments (8)
from jace.pro.
In short order we've integrated Azure intune (for device tracking), solarwinds for network equipment, and crashplan for backups with very minimal work. Then when those different integrations wanted to cahgne something we spent a little extra time on each of them to ensure we could iterate quickly by being consistent and using import sets.
I've been working with servicenow for a long time, and even I am tempted to write directly to the table. However writing direclty to the table is bad because over time the table changes.
- Changing the column, adding a column, dropping a column
- Adding access controls
- Adding abort business rules
All of these can cause the integration to fail at a later date.
However, you have nothing to test to verify the integration is working if you're writing straight to the table except the lack of a record update. Even then the update may be by some other integration.
For these reasons I suggest using import sets for all the integrations where you can.
By doing an import set here's the quick benefits;
- You can insert all the details from the integration, you're not limited to the columns of the target table
- You can massage the data from the other system
- You can easily add/remove data by changing your import set instead of having to re-read and set up your api calls.
from jace.pro.
In this lab we're going to pull users in. I can imagine a number of systems where the users could be beneficial to have them in servicenow;
- Customers (to act as callers from some other intake)
- Leads (to try to sell things to)
- Onboarding (from another system like workday)
In anycase, we're going to be using a simple and free non-sn resource to get the users with lots of data.
https://randomuser.me/api/?page=3&results=10&seed=sn
from jace.pro.
The fields returned are;
- gender
- name.title
- name.first
- name.last
- location.street
- location.city
- location.state
- location.postcode
- email (use this as the coalesc)
- login.username
- dob.date
- phone
- cell
- picture.medium
- nat
Now a lot of these fields don't mean anything to us yet, but initially say the request is to pull in their email and name.
I'd still pull in all the details in initially so you don't have to mess with the import later;
You can easily convert JSON to excel for the import here;
https://codebeautify.org/json-to-excel-converter
Then just replace results.0.
with nothing.
from jace.pro.
We could pull in just name.title + name.first + name.last
However, if we pull all parts of this, we don't have to consider the object until later and we can ask the stake holder if there's other data they want that they also might not even know is available.
from jace.pro.
from jace.pro.
If you don't want to run a transform until you load all the record, you'll need a global script include to allow access to GlideImportSetTransformerWorker.
Otherwise you'll get this if you try to execute code to do it.Evaluator: java.lang.SecurityException: GlideImportSetTransformerWorker is not allowed
Flatten the import data.
Use Import sets, always.
Pull in all available data to import set
from jace.pro.
https://codebeautify.org/json-to-excel-converter
from jace.pro.
Related Issues (20)
- Feature Request - RSS feed for the news HOT 1
- post/2020-05-22-all-the-shortcuts/ HOT 2
- Show code in addition to the screenshot of the code
- is it possible to use this end point mentioned in this post? HOT 3
- Some page have broken styling in the blog HOT 2
- post/2018-06-06-email-scheduled-reminders/ HOT 2
- post/2021-05-07-how-to-export-your-followers-from-twitter-right-now/ HOT 2
- Why extending a sys_user table is problematic HOT 1
- go over http://zoominsoftware.com/
- templates are better - write about this stuff
- post/2020-12-17-cloudflare-pages-netlify-zeit-github-pages-and-gitlab-pages-where-to-host/ HOT 9
- Mirroring choices from tables on catalog items HOT 1
- acl change to emails on activity streams with paris HOT 1
- Fuzzy time script
- How to include data in a scoped application HOT 1
- What is SUBQUERY HOT 1
- How to get the current shard for a table
- post/2019-01-12-kb-approvals/ HOT 2
- Adding Metrics to Scoped tables
- extension points
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jace.pro.