Transform Field map script call via script include

sanjeet1245
Tera Guru

So, firstly we create a custom table have 4 field :-
1. Article No- Type String.
2. Short Description - Type String.
3. Space Key - Type String.
4. Kbbody - Type Html.

Actually we have an excel file, in which we have a field name Kbbody in the following field we have an https link.

Task- Actually we have to create the script include and call the script into transform map. While working on the task we can not able to generate any link in the Kbbody field.

After some hardwork we are able to see some number in the field. By the field map script following script was:-


var sc = new global.scriptinclude_name();
var op = sc.function_name(source.u_kbbody);
source.u_kbbody = op;
gs.info('Transformed KBBody: ' + op);
return op;

By that we need a small requirement.
The following pattern are in regex:-


function_name: function(inputText) {
var regexPattern1 = /<a href="https:\/\/123@mail.com\/wiki\/spaces\/LinkTest\/pages\/(\d+)">([^<]+)<\/a> inline/g;
//The specific pattern we are doing to replace with :-
var outputText = inputText
.replace(regexPattern1, '<p>Linking Page 1 here <a href="123@gmail.com">Page Link</a>')
return outputText;

We need to convert the href link into amslink:12347556(our links coverted into random number

Can anyone suggest me how to achieve this requirement.

Every instruction will be helpful.

Thanks and Regards,

Sanjeet Kumar.

1 ACCEPTED SOLUTION

Make sure you don't use capitol letters so just amslink instead of Amslink


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

10 REPLIES 10

Peter Bodelier
Giga Sage

Hi @sanjeet1245,

 

If I understand your issue correctly, the HTML Sanitizer is changing the amslink in your urls?

 

You can configure which protocols are allowed by following this article:

How to allow list a protocol in the HTMLSanitizerConfig - Support and Troubleshooting (servicenow.co...


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

undefind are coming in the field now . can you guide me how i call my both script include in my field transform script. or i have to call or not  htmlsantizer in field  transform script .

Hi @sanjeet1245,

 

It looks like you are calling your script include correctly.

Within the script include the regex seems to be wrong, but I'm assuming that you have something like

 

<a href="https://123@mail.com/wiki/spaces/LinkTest/pages/12">fdsfs</a> inline

which you want to replace?

If so your regex should be

/<a href="https:\/\/123@mail\.com\/wiki\/spaces\/LinkTest\/pages\/(\d+)">([^<]+)<\/a> inline/g

 Also I don't see you using the amslink part?


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

i am sharing my code with you sir  please go through from thisScreenshot 2023-10-11 201551.png