\nhttps:\/\/www.getpostman.com\/<\/a><\/p>\n
2.<\/strong> Ensure the login ID has sufficient ODATA privileges<\/p>\n 3.<\/strong> Create a new collection. 4.<\/strong> Give your new collection a name and set the authorisation 5. <\/strong>Create a new Post request 5.1<\/strong> Testing your connection details without Inserting.(Optional)<\/strong> 6.\u00a0<\/strong> Adding Header and Body Details Now Select the Body option and ensure the raw radio button has been checked, the below is JSON formatted data which we’ll be sending to the system. This becomes a lot easier to understand when you first try to make a “GET” call to the entity you’re attempting to insert into. Please note the fields in the double brackets. These are your variables which come from the CSV you’re attempting to upload into.<\/p>\n 7.<\/strong> Adding Validation 8.<\/strong> We execute our script Select your CSV file, ensuring the Headers match up with the variables you’ve created in the Body as those are the values that are going to be replaced. Click run, and you should be presented with the results. We hoped this was easy to understand as Successfactors has provided a lot of tools to enable your business to operate without outside expertise. If you have any queries, we’d love to hear from you, as they say<\/p>\n –\u00a0 “To teach is to learn twice”<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" We recently had an issue with Successfactors Recruitment where applicants in a particular status were not picked up by the candidate purge process leaving client liable for breaching data privacy. To correct the issue, we tried a few things such as using the SFAPI to update status(the behaviour inconsistent), and also the Integration Center which … <\/p>\n
\nWhen you start postman you should be presented with a wizard. A collection is just a set of requests you’ll be sending to the server.<\/p>\n![\"\"](\"https:\/\/i0.wp.com\/moresuccessgroup.co.uk\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-04-at-14.21.46-1024x570.png?resize=525%2C292\")
<\/p>\n
\nUnder the authorisation section, Select type “Basic Auth”. Set your username and password. Your username should be your ODATA login name and Instance ID. Please be aware, the login IDs are case-sensitive.<\/p>\n![\"\"](\"https:\/\/i2.wp.com\/moresuccessgroup.co.uk\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-04-at-14.35.49-1024x468.png?resize=525%2C240\")
<\/p>\n
\nClick the little plus button and create the details of your ODATA Upsert. You’ll need to know which data entity you’re inserting into also the URL for your data center. To learn more about the data entity, you can use the “ODATA API Data dictionary” from your BizX instance. To obtain your data center details, use the sap note 2215682<\/a>\u00a0. We’re using the UPSERT call below which also tells the system we’d like the response in JSON format :-
\nhttps:\/\/<<YOUR DATA CENTER>.successfactors.eu\/odata\/v2\/upsert?$format=json
\n<\/em>At this point, the calls are set up but does nothing. We should save. Remember to select the collection you created when saving.<\/p>\n
\nCreate a new request, but this type a “Get” request. Use the URL below :-https:\/\/<<YOUR DATA CENTER>>.successfactors.com\/odata\/v2\/$metadata<\/p>\n
\nSelect your request and choose the Header option. The REST header can contain some control information which we’ll pass to the system.<\/p>\n\n
![\"\"](\"https:\/\/i1.wp.com\/moresuccessgroup.co.uk\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-04-at-15.24.08-1024x307.png?resize=525%2C157\")
<\/p>\n{ \"__metadata\": <\/em>\r\n\u00a0 \u00a0 { \"uri\": \"JobApplication('{{AppliID}}L')\" <\/em>\r\n\u00a0 \u00a0 }, <\/em>\r\n\u00a0 \u00a0 \"applicationId\":\"{{AppliID}}\", <\/em>\r\n\u00a0 \u00a0 \"appStatusSetItemId\": \"202\" , <\/em>\r\n\u00a0 \u00a0 }<\/em>\r\n}<\/em><\/pre>\n
\nPostman has the option of using Scripts the provide validation from. There are some pre made code snippets but these do not suit our needs. We used an existing code snippet and modified it to our expected return code.<\/p>\npm.test(\"Update code\", function () {<\/em>\r\nvar jsonData = pm.response.json();<\/em>\r\npm.expect(jsonData.d[0].httpCode).to.eql(204);<\/em>\r\n});<\/em><\/pre>\n
\nWe’ve tested our connectivity, we have the data we want to UPSERT and we have our validation. We should now be able to run a script to insert data using a CSV file. Select your collection and click the run option. ![\"\"](\"https:\/\/i1.wp.com\/moresuccessgroup.co.uk\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-04-at-15.39.59-1024x625.png?resize=525%2C320\")
<\/p>\n![\"\"](\"https:\/\/i0.wp.com\/moresuccessgroup.co.uk\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-04-at-15.42.30-1024x724.png?resize=525%2C371\")
<\/p>\n