Hi,
I managed to connect the Atomsvc file to my spreadsheet, I would like to run Power Automate Desktop to edit the atomsvc file and then just refresh the spreadsheet.
I tried VBA and it got too complicated so I'm not trying Power Automate Desktop to take on this task.
I don't have a lot of experience with coding, so please bare with me.
I kind of understand the XML language that I know I have to edit in order to change the file.
When trying to use any of the actions that are under "XML", I don't seem to be able to get anything besides being able to Read the file.
My first question is " Is Power Automate Desktop the best option to adjust and edit the file so I can adjust the information that the atomsvc?"
I'm thinking that maybe even if this file has been written as an XML, I might not be able to edit it as one or it operates differently?
Now if XML is the best option or at least a decent option for me to edit my atom file, why am I getting this error?
Here is my XLM source:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<service xmlns="http://www.w3.org/2007/app" xmlns:app="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom">
-<workspace>
<atom:title>Sales Ledger All Orders And Payments</atom:title>
-<collection href="http://mp-ssrs-01/PBIReportServer?%2FReports%2FFinance%2FData%20Exports%2FSales%20Ledger%20All%20Orders%20And%20Payments&StartDate=04%2F01%2F2021%2000%3A00%3A00&EndDate=03%2F31%2F2022%2000%3A00%3A00&rs%3AParameterLanguage=&rs%3ACommand=Render&rs%3AFormat=ATOM&rc%3AItemPath=table1">
<atom:title>table1</atom:title>
</collection>
</workspace>
</service>
And here is a screenshot of my error:
My goal is to edit/adjust the date range that follows after "Start Date" & "End Date", and if possible also the title of the file so I can create or change the report, it might need to change also the http too.
I hope I have provided enough information and that my question made sense.
I look forward for your help.
Thanks,
Pierre Reynaud