- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2025 10:46 PM
Hi @艶博李
Right now, your script is building an object (result) with question and value — but Flow Designer outputs can’t directly “map” nested JSON into columns. You’ll need to explicitly insert/update a record in your target table.
below is your Corrected script:
(function execute(inputs, outputs) {
var reqItemId = inputs.req_item_id;
// Target table (replace with your table)
var targetTable = 'u_target_table';
var m2m = new GlideRecord('sc_item_option_mtom');
m2m.addQuery('request_item', reqItemId);
m2m.query();
while (m2m.next()) {
// Get option and variable
var option = m2m.sc_item_option.getRefRecord();
var variable = option.item_option_new.getRefRecord();
// Extract question & value
var questionText = variable.question.toString();
var valueText = option.value.toString();
// Insert into your target table
var gr = new GlideRecord(targetTable);
gr.initialize();
gr.u_question = questionText; // Column A
gr.u_value = valueText; // Column B
gr.u_request_item = reqItemId; // optional for traceability
gr.insert();
}
outputs.success = true;
})(inputs, outputs);
If you found my response helpful, I would greatly appreciate it if you could mark it as "Accepted Solution" and "Helpful."
Your support not only benefits the community but also encourages me to continue assisting. Thank you so much!
Thanks and Regards
Ravi Gaurav | ServiceNow MVP 2025,2024 | ServiceNow Practice Lead | Solution Architect
CGI
M.Tech in Data Science & AI
YouTube: https://www.youtube.com/@learnservicenowwithravi
LinkedIn: https://www.linkedin.com/in/ravi-gaurav-a67542aa/