Can I add records to SQL Table using WEB App

Help Apps
1

I’m developing a WEB App which will add records to an SQL table based on data on the screen.
Can I do this directly, I mean get the data from screen and insert into SQL table using WEB App ?

Tks.

2

@egameiro

Are you talking about UiPath apps?if yes then you can in oke a process and in process can load data to database

If not and if it is about a general web app then you need to make api calls to db …to do that first you need to check if there are any apis created if not you need to create them

Cheers

3

Hi Anil…

I’m talking about UiPath apps, and I’d like to know if there is a way to directly insert records into SQL Table without use a process (RPA process).
If it is not possible to directly do this inserts into a SQL Table, what other mechanism of persistence exist (in UiPath apps) where I can write and read information.

Thank you for the quick replay.

4

Hi @egameiro

Storing data to a database is not available by default in UiPath apps, instead, you could try the following

  • Using Data Service, and store data to entities. This is fairly easy to use -
  • Have your app to trigger a UiPath job that handles the data storage in a database like sql server - this involves automation flow
  • Use the integration service to send data via api to a database or service Note that: You will need to create the connector if it doesn’t exist.
5

@egameiro

you can use dataservices which is like a database inside UiPath env itself and which can be accessed directly

else you need a process

cheers

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.