Cum pot sa folosesc un API ca sa imi preia date dintr-o baza de date?

Salutare, ma poate ajuta cineva cu acest task? Incerc de cateva ore si nu am niciun progres :frowning:

@david_ilie

welcome to the community

which database are you looking for and are there any api’s configured?

you have to check on their site for api details…

and ideally you would be connecting to db using database connections and retrieve data unless there is some api layer configured for you db

cheers

Deci, am de facut un proces prin care sa se conectere la o evidenta scolara, sa preia catalogul cu notele si sa le salveze intr-un excel. Pentru a se conecta la evidenta ar trebui sa preia datele de conectare dintr-un database(datele de conectare consta in cnp si parola). Acum nu stiu cum sa transmit datele respective la orchestrator/robot. Tin sa mentionez ca sunt nou in acest domeniu si nu stiu foarte multe :sweat_smile:

@david_ilie

You need the connection details to connect to a database

and these activities will help in connecting to db if you have details

https://docs.uipath.com/activities/docs/about-the-database-activities-pack

cheers

Multumesc pentru linkul respectiv. Ai putea sa-mi spui o parere despre proiectul pe care il am si cum te-ai gandi tu sa il faci? M-ar ajuta niste idei :))

@david_ilie

To Start with the log in details will genrally should be available with you and not in any database…

try first checking clearly where you will get the details from

because generally credentials are not stored in a database …

login all all can be done using recorder in UiPath and ui related activities and extraction of data can be done using table extraction

cheers

Ok sa zicem ca am inteles asta(desi nu prea) cum as putea face pentru logarea unui anumit student sa ii selectam doar numele si dupa robotul sa faca procesul de conectare si salvare date in excel? Si cum as putea rula acest proces si pe alt calculator?

@david_ilie

Please go through videos here

cheers

ai si tutoriale legate de orchestrator API?

@david_ilie
Check these:
https://docs.uipath.com/orchestrator/standalone/2022.10/api-guide/api-references

@david_ilie

Orchestrator API is to get data from UiPath orchestrator

cheers