Json to excel from one system to another

hey , currently I am managing opencore dashboard from machine A and I have installed openrpa in machine 2 . I trigger workflows from machine A which runs on machine B . now the solution or idea I need is nodered workflow for :- from machine A (opencore enabled system ) I have to read the json format data through an api . convert it to csv and then save it as a excel file into the local disk of machine B ( openrpa installed machine) so that openrpa could process its workflow on that data . any solutions or ideas on how could this work ?

I had to look that up, even now, I am not really any the wiser, so will leave that for you to work out the API details…
But, to your question, for tasks like this I find it best to break it down. Don’t try and do the whole flow at once.

Lets look at just first thing you need to do…

You don’t mention what is going to trigger the API, so lets just use an inject node that is set to manual.

It is CRITICAL that you do NOT add any more nodes until you have the API call returning JSON.
Don’t rush, don’t try and jump ahead.

Ok, so once that is up and running and we can see the JSON, whats the next step?

For that, we will need the CSV node…

And the last part…

For that, we need the file node…

By building the flow up part by part, you should be able to ensure each section is working correct before adding the next.

2 Likes

thanks Beno . but what if I am working on opencore and nodered and my team member is working on openrpa. our opencore is hosted and deployed securely . my team member’s openrpa is connected to the opencore I am working on . so I have a api of json format data . now how can I make a flow in nodered so that I can save this json format data I have in api into my team member’s machine( his system’s local disk ) .

I did wonder how all this was running on EPIC.
Since its your application and hardware/network, you will need to work out where Node-RED runs to achieve the desired result. Its impossible for me to advise about software that Opto has no hand in.