Help with Business Rule attaching a file from the business app request to business application

[Mollie V]

Hi,

I was advised by HI support to create a before insert business rule to copy attachments from the Business Application Request record (business_app_request) to the Business Application (cmdb_ci_business_app) record using the following script. HI provided this reference GlideSysAttachment | ServiceNow Developers.

It works great when I know the sys_id.

var source_sysId = '1d3aca2e1bb5a9503c5f97d4bd4bcbe6';

var gr = new GlideRecord('business_app_request');
gr.addQuery('sys_id', source_sysId);
gr.query();
while (gr.next()) {
Packages.com.glide.ui.SysAttachment.copy("business_app_request", gr.sys_id, "cmdb_ci_business_app", current.sys_id);
}

The business_app_request is created from a catalog request and the flow creates the cmdb_ci_business_app. Since copying the attachment is not standard functionality, I need to create a BR to do this.

Can someone clarify how to access the source record, in this case the business_app_request that is created from the catalog request, to get the attachment sys_id?

Thanks,

Mollie

[Allen Andreas · Accepted solution]

Hi,

Are you able to insert the copy attachment action as part of this flow? Where you have access to both the sys_id for both the business app and the cmdb_ci_business_app?

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/administer/flow-designer/reference/... -- this can be done without code and just dragging the relevant pills to the configuration.

[Allen Andreas · Accepted solution]

Hi,

Are you able to insert the copy attachment action as part of this flow? Where you have access to both the sys_id for both the business app and the cmdb_ci_business_app?

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/administer/flow-designer/reference/... -- this can be done without code and just dragging the relevant pills to the configuration.

[Mollie V]

Hi, Allen,

Interesting. No, I have not tried but will try it. Stay tuned.

Thanks for the reference.

[Allen Andreas]

Hi,

Ok. Glad my replies have been helpful to gain more information and then allowed me to try and suggest a no-code solution that uses the same flow you're already in where you have access to both record sys_ids.

If my reply above helps guide you Correctly, please consider marking it as "Accept Solution".

Thanks!

[Mollie V]

Hi,

It looks promising and I agree that a no-code solution is best.  However, I'm running into an issue where the target record is not available in the flow. 

The Create Business App action that creates the target record does not return the sys_id. This is oob script that it executes.

I might have to add additional actions such as Lookup the newly created cmdb_ci_business_app and get the sys_id that way? I'm new to Flows and still trying to figure out the best way use it.

[Mollie V]

Hi, Allen. I just want to close the loop on this. The Copy Attachment is not as straightforward as described.

I ended up executing a Lookup Attachment action, followed by a Look up record to get the attachment record, then use the attachment record as the source for the Copy Attachment action. It wasn't taking the business_app_request record as the source and was giving an error.

This is what it looks like and it's working as expected.

Thank you for your help and guidance.