First you need to add the resource.
- Click the +
- Choose Data Resource
- Click Create Record
- Click Add.
Under Data Resources you now have a "Create Record 1". Congrats.
But you want to use it in a Client Script, because scripting always feels better.
Here's the code:
api.data.create_record_1.execute({
table: 'INSERT_TABLE_NAME_HERE',
templateFields: 'FIELD_NAME=VALUE^FIELD_NAME_2=VALUE_2',
useSetDisplayValue: null,
});
// NOTE: the ^ after VALUE. This allows you to chain field names and values together to set all the fields you want to set on your new record.
BUT WAIT THERE'S MORE
Because you're a savvy ServiceNow Developer, you want to make sure you get the record details for the new record you created.
- Go to your Create Record 1 Data Resource and click it.
- On the modal that opens, find "Events" and click it.
- Click the "+ Add event mapping" button
- Choose "Operation Succeeded"
- Click the "+ Add event handler"
This is where it will get a bit tricky
The information you want is from the event. In the below example, I'm just setting a client state param to the sys_id of the newly created record. Obviously, you can do whatever you want with it. OR you could use the console.log statement under the long dot walk to see all the other available data returned from this operation.
function evaluateEvent({api, event}) {
const new_user_id = event.payload.data.output.data.GlideRecord_Mutation.insert_sys_user.sys_id.value;
//console.log(JSON.stringify(event.payload.data, null, 4))
return {
propName: 'new_user_id',
value: new_user_id,
};
}
// Things to note about the above code
// After GlideRecord_Mutation is "insert_YOUR_TABLE_NAME"
// If you are having a hard time getting the dot walk to work, use the commented out code under "const new_user_id" and find the dot walk path in your dev console, in browser.
