Hello all,
Does anyone knows how can I connect the UiPath cloud via Swagger to excel ?
-Connections details (how to connect? Token?..)
Can you elaborate
what do you mean cloud to swagger to excel?
swagger will have api details to connect and get data or modify the data on orchestrator…what you want to do on excel?
cheers
Hello,
I mean in my old company we had an excel file connected to API via externa app. But that company the orchestartor was on premisse.
now I work in a company that uses cloud UiPath/orhestrator.
So i wanted to do the same thing.
Using powerquery in the M language. This way I can filter by jobs, queues, triggers, etc.
The idea is to have a decentralized Excel where the customer can have real-time information about the robot’s statistics, just by clicking on refresh.
So it would be. Get data > powerquery (here I can filter by multiple ways).
Example:
For each folder > get single jobs > queues > get queue items > success? Fail?
Something like that. but the first thing would be to be able to make the connection. the powerquery issue would come later and would be to refine the data I need.
you would need to generate your bearer token. Choose anonymous option while connecting
Thank you I’ll try.
To generate a Bearer Token I’ll need something like postman right ?
yes postman, python etc.
here is the code which i use
import tomllib
import requests
with open("config.toml", "rb") as f:
cfg = tomllib.load(f)
tokenurl = cfg["keys"]["token_url"]
body = {
"grant_type": "refresh_token",
"client_id": cfg["keys"]["client_id"],
"refresh_token": cfg["keys"]["refresh_token"],
}
headers = {"Authorization": "Bearer", "Content-Type": "application/json"}
response = requests.post(tokenurl, json=body, headers=headers)
client id and refresh token you will have to fetch from the admin panel of your orchestrator
token url =“https://account.uipath.com/oauth/token”
1 Like
Thank you! You gave me the directuon
Now i just need to test and build.