- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2023 10:22 AM - edited 09-28-2023 05:04 AM
Hi,
How to get the value of repository id and Name from the source data field by using array?
source data: {"assetexposurescore":"497","repository":"{\"id\" : \"36\", \"name\" : \"(01) - Health Services - ActiveScan\", \"description\" : \"Health Services - ActiveScan\", \"dataFormat\" : \"IPv4\"}","score":"40","acrscore":"4.0",
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2023 08:39 PM
As it contains escape characters so we need to first remove the escape characters.
Refer the below Steps :
// 1.Store result in variable , Just for simplicity I have taken only some data from your JSON object
var result = {"assetexposurescore":"497","repository":"{\"id\" : \"36\", \"name\" : \"(01) - Health Services - ActiveScan\", \"description\" : \"Health Services - ActiveScan\", \"dataFormat\" : \"IPv4\"}"}
// 2. Stringyfy the result so that we can remove escape characters
var stResult = JSON.stringify(result);
// 3. replace the escape characters
var newResult = stResult.replace( /\'\'/g,'');
// 4. convert it into object again
var parser = JSON.parse(newResult);
// 5. get the repository object form newly created object
var repository = parser.repository;
//gs.info('repostory=' + repository);
// 6. Create new JSON objectas repository contains string
var newObj = {
repoData : {},
}
// 7. add parsed repository into new JSON
newObj.repoData = JSON.parse(repository);
// 8. get the values by dot walking
gs.info("Id = " + newObj.repoData.id);
gs.info("name = " + newObj.repoData.name);
Output :
ServiceNow Developer
I know one thing, and that is that I know nothing.
- Socrates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2023 05:02 AM
Hi @Vishal Birajdar ,
Issue has been resolved, I am sharing my updated fix script.
And Thank you so much for all your help, which really helps me a lot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 10:27 PM
Screenshot of fix script please...!!
ServiceNow Developer
I know one thing, and that is that I know nothing.
- Socrates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 10:41 PM - edited 09-28-2023 05:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 10:54 PM
The code looks good..!!
Try to put semi-colon (;) in line no. 11 after curly braces (})
like this };
ServiceNow Developer
I know one thing, and that is that I know nothing.
- Socrates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 11:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 11:37 PM
Only option is to debug the script by putting some logs.
Check in logs what you are getting in 'repository' variable.
The error may be because of empty value is passed in JSON at line 12.
ServiceNow Developer
I know one thing, and that is that I know nothing.
- Socrates