Is it possible to fetch the value of a single score report using script?

Suggy
Giga Sage

I have a report like this - a single score report. I need to its value using a script. Is it possible?

Reason - I need this value to do some calculations, send emails based on that value etc

 

Sample single score report I am talking about-

Suggy_0-1745495339412.png

 

1 ACCEPTED SOLUTION

Vishal Jaswal
Giga Sage

Hello @Suggy 

 

Not from report though however from a fix script or flow (better option - no code) you can get it and send e-mail too.

 

You can create one parent flow and have multiple sub flows within to achieve all of your use cases (if you want to).

 

This flow can be scheduled or triggered based upon records creation/updation.


Hope that helps!

View solution in original post

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Suggy 

 

If something is available out of the box (OOTB) without the need for scripting, why would you need to use scripting for it?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Atul, I need that value for various reasons like for calculating something else, sending emails etc. Its a sample report I shared above. We have several score type reports and need the values of it to use it in our use cases.

Hi @Suggy 

Thanks for the clarity! I think I agree with @Vishal Jaswal  that if you just need the count, but in a flow, you need to figure out how to handle other types of data. I might be wrong, but can't you use the report output to send the details, or maybe use the reports directly for your purpose?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@Suggy 

so are you planning to use scheduled job to send emails etc?

what's the actual business requirement since sending email and reporting are 2 different things

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader