cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PierreReynaud1
New Member

ATOMSVC edit file using XML

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:

PierreReynaud1_0-1666024422768.png

 

 

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

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,058)