Тёмный
No video :(

Automate File Uploads with UiPath: The Complete Guide 

UiPath Video Tutorials made by Cristian Negulescu
Подписаться 6 тыс.
Просмотров 10 тыс.
50% 1

Опубликовано:

 

5 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 31   
@CristianNegulescu
@CristianNegulescu 3 года назад
0:20​ cURL example 1:35​ Send the command from POSTMAN 2:50​ Implement the code in C# 4:20​ Run the code 4:50​ Visual Basic code VB.NET 6:20​ New Process on UiPath Studio with Invoke Code 7:20​ Imports Libraries in UiPath Studio 8:30​ Run the Robot to Upload and Download the file Code: github.com/cristinegulescu/st...
@MrDALJIT123
@MrDALJIT123 3 года назад
Same goes to me i have installed all the package as per your video but i still having invoke code erorr 1. Type httpwebrequest is not defined 2. Webrequestmethode is not declared 3. Httpwebresponesd not define Looks like they are not member of system.net.http
@CristianNegulescu
@CristianNegulescu 3 года назад
@@MrDALJIT123 so please look again on part from 7:20 to 8:20 be sure that you install System.Net.Http the add on the Imports System.HTTP and System.Http.headers next click Save on all the workflows. Restart UiPath Studio (Close Studio and reopen Studio on this project and open your file that where you have the invoke code)
@RPAChampion
@RPAChampion 3 года назад
He Christian , great video , this is Greg from Linkedin great to meet and take inspiration from your channel
@ariangeldiazespaillat4376
@ariangeldiazespaillat4376 3 года назад
This worked smoothly for me!
@raleigh5here182
@raleigh5here182 2 года назад
Thank you tremendously for this excellent, detailed post. I found it very helpful.
@CristianNegulescu
@CristianNegulescu 2 года назад
My pleasure like share and subscribe
@patoche316
@patoche316 3 месяца назад
I have seen that there is a multipart form-data editor now for the Http Request Activity that let you specify the body type and add a few properties without having to use any Invoke-Code. I am using studio 2024.2.1 but cannot see it. Perhaps you know a what I would be missing ?
@CristianNegulescu
@CristianNegulescu 3 месяца назад
Sorry, now I see the comment. I check on my latest studio and I don't see multipart form-data. I did my latest update. You don't need to be scary about invoking code is very safe and you control everything from that code.
@coolbroro-ds2qf
@coolbroro-ds2qf 10 месяцев назад
Hey Cristian, Are you able to upload the excel file (.xlsx) by using the same approach? if so, please let me know the headers
@CristianNegulescu
@CristianNegulescu 10 месяцев назад
Normally yes but you need to search on the internet for the for header value for excel what is on the movie is for word
@manikantasivakumar9925
@manikantasivakumar9925 3 года назад
getting below error: error CS0246: The type or namespace name 'HttpRequestMessage' could not be found (are you missing a using directive or an assembly reference?) At line 2
@CristianNegulescu
@CristianNegulescu 3 года назад
Please do all the steps from minute 7:20 to 8:30 and then restart UiPath Studio.
@mdmashkooralam7483
@mdmashkooralam7483 3 года назад
Hi Christian, Excel file corrupted after uploading .xlsx file to SharePoint with VB.NET, I got that error message while opening excel file after uploaded to SharePoint "Excel cannot open the file 'Input.xlsx' because the file format or file extension is not valid. Verify that the file has not been currented and that the file extension matches the format of the file". Can you please share the VB.NET code to upload .xlsx file SharePoint.
@CristianNegulescu
@CristianNegulescu 3 года назад
I never use SharePoint with VB.NET because authentification is tricky. From what I know my colleagues use this component to interact with SharePoint marketplace.uipath.com/listings/sharepoint-custom-activities-package
@mdmashkooralam7483
@mdmashkooralam7483 3 года назад
But you already uploaded .docx file to SharePoint with the help of VB.NET and also share GitHub URL in description. So can you share code to upload .xlsx file instead of .docx file
@CristianNegulescu
@CristianNegulescu 3 года назад
@@mdmashkooralam7483 This example is with DOCX but not do upload to share point A client gives me one of their servers with their protocol. Give me 5 minutes to look at my Code maybe I will be able to understand what can be different on EXCEL.
@CristianNegulescu
@CristianNegulescu 3 года назад
@@mdmashkooralam7483 so take a look here stackoverflow.com/questions/4212861/what-is-a-correct-mime-type-for-docx-pptx-etc did you put for XLSX this media format application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
@mdmashkooralam7483
@mdmashkooralam7483 3 года назад
Hi Cristian, I put "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" but i got same issue.
@fekiee
@fekiee 3 года назад
Hi, GREAT CONTENT HERE, Thanks, I need to upload a file to Zendesk, I saw you have some customers activities ready but I couldn't get them downloaded, where do I get these files?
@CristianNegulescu
@CristianNegulescu 3 года назад
Hello Jin, The zendesk component is discontinued I can give you the code from the Upload procedure: HttpWebRequest request = (HttpWebRequest)WebRequest.Create(serviceURL+"/api/v2/uploads.json?filename="+JustName); request.Method = "POST"; request.Accept = "application/binary"; request.Timeout = 100000000; request.Headers.Add("Authorization", authToken); Byte[] bytes = File.ReadAllBytes(nameDecision); request.ContentType = "application/binary"; request.ContentLength = bytes.Length; // stream Stream requestStream = request.GetRequestStream(); requestStream.Write(bytes, 0, bytes.Length); requestStream.Close(); var res = request.GetResponse(); var response = res as HttpWebResponse; string responseFromServer = string.Empty; using (var responseStream = response.GetResponseStream()) { using (var reader = new StreamReader(responseStream)) { responseFromServer = reader.ReadToEnd(); } } Response = responseFromServer; if (response.StatusCode == HttpStatusCode.Created) { ValidConnection = true; JObject sObjJObj = JObject.Parse(Response); JToken tokens = sObjJObj["upload"]; foreach (JProperty jp in tokens) { if (jp.Name == "token") { ID = "+++"+jp.Value.ToString(); } if (jp.Name == "attachment") { JToken tokens2 = tokens["attachment"]; foreach (JProperty jp2 in tokens2) { if (jp2.Name == "id") { ID = jp2.Value.ToString() + ID; } } } } }
@navneetpanpaliya9873
@navneetpanpaliya9873 3 года назад
Hello Cristian, I am trying to read excel file from OpenText (Content Server) using HttpRequest ---> GET (multipart form-data) I am able to get response which is in bad tag format (stream data / binary data) as string same as you shown in your video. Can you please help me to convert this string (binary data) to steam or datatable? How do I read excel file and get its data in datatable using API? Thanks & Regards, Navneet
@CristianNegulescu
@CristianNegulescu 3 года назад
Hello Navneet, Please check this video : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EeRt8NEfo-w.html from 6:05 to 7:05 you need to write the file on the harddisk and then you will read this with dedicated activities to read excel. You have all the code inside of the video description. For testing try to Use Visual Studio will be much faster.
@saikumarkuncha
@saikumarkuncha Год назад
I am unable to find the code at Git hub could you please provide the code
@CristianNegulescu
@CristianNegulescu Год назад
Code: github.com/cristinegulescu/startUiPathFromSalesforce/blob/master/FormData.txt
@CristianNegulescu
@CristianNegulescu 2 года назад
EP1 Start UiPath Process from Postman Cloud | OnPrem | Modern Folder ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tLN_p8swHS4.html EP2 Configure Salesforce to work with UiPath ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TwP5dcs4K2g.html EP3 Deserialize JSON in UiPath ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Tn5X-7kxzhs.html EP4 Work with CSV files in UiPath (ODBC database) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CaCKlINqrRs.html EP5 Create JSON in UiPath Studio using VB.NET ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cojORhYrBsQ.html EP6 UiPath delete files and folders | 6 use-case ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DrU4WDOKojA.html EP7 UiPath Studio upload files using VB.NET | Form-data ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kpH5pIZk-N4.html EP8 UiPath download files via VB.NET code ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FX9oBEVhnrY.html EP9 Gmail configuration for UiPath email automation ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iIPFpe127JM.html Ep10 Outlook filters for UiPath automation ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9OgAaEoTFA8.html Ep11 Regex in UiPath simple presentation ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mesRfWjNycQ.html Ep12 6 use-cases of using LINQ in UiPath Studio ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uibImumRGGM.html Ep13 Initialize Lists and DataTables in UiPath ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OP3-87nWpZM.html Ep14 Try Catch and throw/rethrow in UiPath Studio ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CvdP8aCwLNY.html Ep15 Dynamic selectors in UiPath with a variable inside ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6dy36HpnR6o.html
@tharaninatarajan2248
@tharaninatarajan2248 3 года назад
Can we use the same to call it via excel macro?if so can u please help
@CristianNegulescu
@CristianNegulescu 3 года назад
I don't know if VBA is the same as VB.NET but you can try. Check this movie to see how I do some HTTP request from Excel ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVSsFnI0fIo.html You just need to combine the codes and try.
@tharaninatarajan2248
@tharaninatarajan2248 3 года назад
@@CristianNegulescu Thanks for the quick reply.I am able to do POST CALL with VBA.facing difficulty while attaching file .
Далее
Automate Your File Uploads & Downloads with UiPath
11:22
How to get Spongebob El Primo FOR FREE!
01:36
Просмотров 13 млн
Building the world's LARGEST iPhone
32:05
Просмотров 237 тыс.
Is ChatGPT the Future of Data Extraction?
32:14
Automate ANYTHING with ChatGPT & UiPath
13:39
How to get Spongebob El Primo FOR FREE!
01:36
Просмотров 13 млн