{"id":1692,"date":"2024-09-18T13:11:05","date_gmt":"2024-09-18T12:11:05","guid":{"rendered":"https:\/\/france.magicsoftware.com\/blog\/?p=1692"},"modified":"2025-03-04T17:06:04","modified_gmt":"2025-03-04T16:06:04","slug":"servicenow-magic-xpi","status":"publish","type":"post","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/servicenow-magic-xpi\/","title":{"rendered":"Servicenow &#8211; Magic xpi"},"content":{"rendered":"\n<p class=\"has-medium-font-size\"><strong>Goal : Get, Create Incident with Magic xpi using servicenow REST API<\/strong><\/p>\n\n\n\n<p><strong>Prerequisites <\/strong>:<\/p>\n\n\n\n<p>1\/ Create your servicenow instance (<a href=\"https:\/\/developer.servicenow.com\/dev.do\">https:\/\/developer.servicenow.com\/dev.do<\/a>) and verify that your user has admin role in other to be able to access Application registry on your instance<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"485\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow2-1024x485.png\" alt=\"\" class=\"wp-image-1699\" style=\"width:610px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow2-1024x485.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow2-300x142.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow2-768x364.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow2.png 1235w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"623\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow3-1024x623.png\" alt=\"\" class=\"wp-image-1701\" style=\"width:598px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow3-1024x623.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow3-300x183.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow3-768x467.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow3.png 1218w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"869\" height=\"474\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow4.png\" alt=\"\" class=\"wp-image-1706\" style=\"width:548px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow4.png 869w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow4-300x164.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow4-768x419.png 768w\" sizes=\"auto, (max-width: 869px) 100vw, 869px\" \/><\/figure>\n\n\n\n<p>2\/ Create an Application OAuth<\/p>\n\n\n\n<p>Log in to your servicenow instance with your admin user and search for OAuth<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"465\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow5-1024x465.png\" alt=\"\" class=\"wp-image-1709\" style=\"width:677px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow5-1024x465.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow5-300x136.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow5-768x349.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow5.png 1078w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Create a new OAuth Application<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"200\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1-1024x200.png\" alt=\"\" class=\"wp-image-1829\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1-1024x200.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1-300x59.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1-768x150.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1-1536x300.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow6-1.png 1856w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"275\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow7.png\" alt=\"\" class=\"wp-image-1715\" style=\"width:601px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow7.png 730w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow7-300x113.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"461\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow8-1024x461.png\" alt=\"\" class=\"wp-image-1717\" style=\"width:742px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow8-1024x461.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow8-300x135.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow8-768x346.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow8.png 1461w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Give a name and leave Client secret blank (it will be generated automatically) and click Save (right clic on top grey area)<\/p>\n\n\n\n<p>After saving, copy the Name, ClientID and ClientSecret<\/p>\n\n\n\n<p>3\/ Create a dedicated user to access the API<\/p>\n\n\n\n<p>Search for users and access the users list<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"716\" height=\"672\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow9.png\" alt=\"\" class=\"wp-image-1725\" style=\"width:438px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow9.png 716w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow9-300x282.png 300w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/figure>\n\n\n\n<p>Create a user <strong>magicxpi <\/strong>and grant him an <strong>admin role<\/strong>( to be able to access everything , you can of course adjust the roles) and Tic the check Box <strong>\u00ab\u00a0Web service access on<\/strong>ly\u00a0\u00bb<\/p>\n\n\n\n<p>(the user will be an API user and not a UI user)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Save the new user information (right clic on grey top area)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click Set Password<\/li>\n\n\n\n<li>Generate Password <\/li>\n\n\n\n<li>Copy the password<\/li>\n\n\n\n<li>click Save Password<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"595\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow10-1024x595.png\" alt=\"\" class=\"wp-image-1729\" style=\"width:702px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow10-1024x595.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow10-300x174.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow10-768x446.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow10.png 1495w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4\/ Check with REST API explorer that it&rsquo;s working<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"660\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow11.png\" alt=\"\" class=\"wp-image-1736\" style=\"width:532px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow11.png 744w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow11-300x266.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"497\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow12-1024x497.png\" alt=\"\" class=\"wp-image-1739\" style=\"width:700px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow12-1024x497.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow12-300x146.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow12-768x373.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow12.png 1302w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Choose Incident tablename and click Send, you should receveive 200 Http status code<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"454\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow13-1024x454.png\" alt=\"\" class=\"wp-image-1742\" style=\"width:530px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow13-1024x454.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow13-300x133.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow13-768x340.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow13.png 1368w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>5\/ Check with Postman<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check that you can get the token <\/li>\n<\/ul>\n\n\n\n<p>Do a POST on this URL (<strong>https:\/\/&lt;yourinstance&gt;.service-now.com\/oauth_token.do<\/strong>)<\/p>\n\n\n\n<p>Set the body with all the relevant information in x-www-form-urlencoded<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow14-1024x533.png\" alt=\"\" class=\"wp-image-1746\" style=\"width:578px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow14-1024x533.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow14-300x156.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow14-768x400.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow14.png 1156w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check that you can retrieve the incident List<\/li>\n<\/ul>\n\n\n\n<p>Create a new request and do a GET on <strong>https:\/\/&lt;yourinstance&gt;.com\/api\/now\/v2\/table\/incident?sysparm_limit=10<\/strong><\/p>\n\n\n\n<p>add in the Header : Authorization with value Bearer &lt;access_token&gt;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"610\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow15-1024x610.png\" alt=\"\" class=\"wp-image-1754\" style=\"width:659px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow15-1024x610.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow15-300x179.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow15-768x457.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow15.png 1194w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>6\/ Go back to API Explorer in your instance and Export the yaml file from servicenow that corresponds to Table API<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"557\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow16.png\" alt=\"\" class=\"wp-image-1759\" style=\"width:661px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow16.png 979w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow16-300x171.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow16-768x437.png 768w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/figure>\n\n\n\n<p>Modify the yaml file. Add under parameters (use <a href=\"https:\/\/editor.swagger.io\" title=\"\">https:\/\/editor.swagger.io<\/a>)<\/p>\n\n\n\n<p><strong>name: \u00ab\u00a0Authorization\u00a0\u00bb<br>in: header<br>required: true<br>schema: {type: string}<\/strong><\/p>\n\n\n\n<p><strong>Remove \/ and the end of the url (servers)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"433\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1-1024x433.png\" alt=\"\" class=\"wp-image-1782\" style=\"width:1084px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1-1024x433.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1-300x127.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1-768x325.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1-1536x649.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow17-1.png 1725w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Save the new yaml file.<\/p>\n\n\n\n<p>7\/ Open your magic xpi project and Create a REST Client resource for the Access Token<\/p>\n\n\n\n<p>Servicenow token URL is : https:\/\/&lt;yourinstance&gt;.service-now.com\/oauth_token.do<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"301\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow18-1024x301.png\" alt=\"\" class=\"wp-image-1771\" style=\"width:876px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow18-1024x301.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow18-300x88.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow18-768x225.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow18.png 1090w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>8\/ Create another REST Client resource to access the servicenow  TABLE_API (RESTServicenowTable)<\/p>\n\n\n\n<p>Load the previous yaml file<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"680\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow19-1024x680.png\" alt=\"\" class=\"wp-image-1777\" style=\"width:793px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow19-1024x680.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow19-300x199.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow19-768x510.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow19.png 1160w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Click on Paths, you should discover all the available Paths<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"570\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow20-1024x570.png\" alt=\"\" class=\"wp-image-1790\" style=\"width:657px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow20-1024x570.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow20-300x167.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow20-768x428.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow20.png 1250w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>For the first Path, you should have Keywork \u00ab\u00a0Authorization\u00a0\u00bb in the header tab control<\/p>\n\n\n\n<p>(*) if you want to have this keyword for all paths, you should add the keyword in the yaml file (step 6)<\/p>\n\n\n\n<p>9\/ Create a new flow <\/p>\n\n\n\n<p>Create 2 flow variables (<strong>F.BodyToken (Blob), F.Token (alpha unlimited)<\/strong>)<\/p>\n\n\n\n<p>Update F.BodyToken with the body information<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"318\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow21-1024x318.png\" alt=\"\" class=\"wp-image-1797\" style=\"width:685px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow21-1024x318.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow21-300x93.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow21-768x239.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow21.png 1185w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>10\/ Drag &amp; Drop REST Client connector<\/p>\n\n\n\n<p>Link the step to the Token Resource<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow22-1024x537.png\" alt=\"\" class=\"wp-image-1801\" style=\"width:638px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow22-1024x537.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow22-300x157.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow22-768x403.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow22.png 1373w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"822\" height=\"605\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow23.png\" alt=\"\" class=\"wp-image-1804\" style=\"width:494px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow23.png 822w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow23-300x221.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow23-768x565.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/figure>\n\n\n\n<p>Click OK and set DataBlob to F.BodyToken<\/p>\n\n\n\n<p>11\/ Get the access_token<\/p>\n\n\n\n<p>use a flow data and update the F.Token with the expression <strong>&lsquo;Bearer &lsquo;&amp;StrToken (C.UserBlob,4,'\u00a0\u00bb&lsquo;)<\/strong><\/p>\n\n\n\n<p>(*) you can use a datamapper to parse the json<\/p>\n\n\n\n<p>12\/ Drag &amp; Drop a new REST Client connector<\/p>\n\n\n\n<p>Link the step to the \u00ab\u00a0RESTServicenowTable\u00a0\u00bb<\/p>\n\n\n\n<p>Choose a <strong>GET<\/strong> on path : <strong>\/api\/now\/table\/{tableName}<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"646\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow24-1-1024x646.png\" alt=\"\" class=\"wp-image-1816\" style=\"width:771px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow24-1-1024x646.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow24-1-300x189.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow24-1-768x485.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow24-1.png 1114w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can set the parameters like below<\/p>\n\n\n\n<p><strong>sysparm_query <\/strong>:  description LIKElaptop (to filter with \u00ab\u00a0like\u00a0\u00bb clause on description)<\/p>\n\n\n\n<p><strong>sysparm_fields <\/strong>: &lsquo;number,resolved_by,opened_by,description&rsquo;  (to retrieve only these fields)<\/p>\n\n\n\n<p><strong>sysparm_limit <\/strong>: &rsquo;20&rsquo;  (to limit the result to 20 occurences)<\/p>\n\n\n\n<p><strong>Authorization<\/strong> : trim(F.token)  (to pass the autorization header)<\/p>\n\n\n\n<p>(*) for the other parameters, set them to null<\/p>\n\n\n\n<p>13\/ Execute the flow in debug mode<\/p>\n\n\n\n<p>You should get a 200 HTTP Status code with OK<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"443\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow25-1024x443.png\" alt=\"\" class=\"wp-image-1822\" style=\"width:709px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow25-1024x443.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow25-300x130.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow25-768x333.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow25.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>14\/ Create an Incident<\/p>\n\n\n\n<p>create a Flow variable (<strong>F.BodyIncident<\/strong> blob) and update this variable with the requested json<\/p>\n\n\n\n<p>&lsquo;<strong>{\u00ab\u00a0description\u00a0\u00bb:\u00a0\u00bbtest3&Prime;,\u00a0\u00bbshort_description\u00a0\u00bb: \u00ab\u00a0this is a short description3\u00a0\u00bb}<\/strong>&lsquo;<\/p>\n\n\n\n<p>15\/ Drag &amp; Drop a REST Client connector<\/p>\n\n\n\n<p>Do a POST on <strong>https:\/\/&lt;yourinstance&gt;.service-now.com\/api\/now\/v2\/table\/incident<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"648\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow27.png\" alt=\"\" class=\"wp-image-1852\" style=\"width:560px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow27.png 894w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow27-300x217.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow27-768x557.png 768w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/figure>\n\n\n\n<p>set the <strong>DataBlob <\/strong>to <strong>F.BodyIncident<\/strong> and <strong>tableName<\/strong> to <strong>Incident<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"688\" height=\"201\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow28.png\" alt=\"\" class=\"wp-image-1858\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow28.png 688w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow28-300x88.png 300w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/figure>\n\n\n\n<p>16\/ Execute the flow in debug mode<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"618\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow29-1024x618.png\" alt=\"\" class=\"wp-image-1863\" style=\"width:681px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow29-1024x618.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow29-300x181.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow29-768x463.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow29.png 1248w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>you should receive HTTP Status Code 201 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow30-1024x439.png\" alt=\"\" class=\"wp-image-1867\" style=\"width:735px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow30-1024x439.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow30-300x129.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow30-768x329.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow30.png 1140w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Goal : Get, Create Incident with Magic xpi using servicenow REST API Prerequisites : 1\/ Create your servicenow instance (https:\/\/developer.servicenow.com\/dev.do) and verify that your user has admin role in other to be able to access Application registry on your instance 2\/ Create an Application OAuth Log in to your servicenow instance with your admin user [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1694,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4,54],"tags":[14,55],"class_list":["post-1692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magic-xpi","category-servicenow","tag-magic-xpi","tag-servicenow"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/ServiceNow1.png","_links":{"self":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=1692"}],"version-history":[{"count":102,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1692\/revisions"}],"predecessor-version":[{"id":2885,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1692\/revisions\/2885"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media\/1694"}],"wp:attachment":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=1692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=1692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=1692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}