Extract JSON Data from REST Web Service Response | String Operations | Automation Anywhere A2019 #12

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@debasispatro5573]

Can you provide some input about using javascript how we are extracting json data

[@jasmingantayat1412]

The way you explain is easy to understand for a lay man as well.. looking forward to watch more videos.

[@clamum]

This was helpful for A2019; thank you!

[@marcr2204]

Very cool. Great teaching skills.

[@mohammadrafishaik2347]

nice Explanation. Good to learn from here.

[@filiplou74]

Excellent tutorials, thanks so much!

[@arunpillai311]

Thanks. Very clear presentation

[@sadhiksheneeb2282]

Hi, this example shows one id, However if my JSON returns multiple ids, how can we parse the Ids and save it to a list for looping ?

[@nisharaj449]

Thank you for the videos. It was really helpful in learning A2019. it would be great if you could create a video on accessing the Sharepoint using Automation Anywhere2019

[@romaverma1282]

Hi as i am beginner, i was trying to scrap the data from web table and insert in queue and after that i have to use that data so can u tell how can i get that data from queue

[@PriyankaSingh-iq4te]

Hi, Is there a way to extract response status code in a variable? like 200, 404 etc.

[@kohoory]

Hi thx for ur video, but can u help me pls, I try to read a Json array how i do that on AA? without a metabot

[@qualityassurancelab7764]

Hi, could you please share me your query alongwith JSON Array at [e-mail]?

[@gauravagarwal750]

How do I get to know what dictionary key is to be used?

[@grigorev_evgeniy]

Hi. Why you not use JsonParser -> Json to Dictionary? It'i best practice, imho.

[@andrepp5582]

Hello, i'm a begginer in AA19 and i'm facing troubles on downloading multiple pdf files from a dynamic table in a web site. The files are released each one in a line of this table. Togheter with them, there are other type of files, like XML data. Everyday the number of lines change (according to the # of files released in the website). I would like to set a bot to daily download only the pdf files released. Can you help me on how to do that or even sharing the main steps to build the bot? Thank you so much! Regards.

[@clamum]

I think the key here is what properties you use after you do the Recorder: Capture of the links. I'd venture to guess that it would take some modification to the DOMXPath in order to locate the links, regardless of where they're located in the table (since they can change and are dynamic). I don't think I could really help much further unless I could see the HTML source of the table in question. What you need to do, basically, is find a DOMXPath statement that uniquely identifies the link(s), no matter where they are in the table. That's why I mention DOMXPath and not just Path; you most likely do not want to use Path in the capture properties of the object because it's best for static objects. I'd probably just use DOMXPath and maybe HTML Tag and possibly HTML Innertext as properties for these PDF links. Hope that helps. EDIT: I'm guessing you figured something out since it's been 3 months lol

[@vbalearningtutorials9758]

Hello Mam please let me know how can we extract the information from multiple pages using automation anywhere v11and same how to download files from multiple urls.please help

[@qualityassurancelab7764]

Hi, could you please let me know what element you want to extract and are the multiple pages related pages (Do they make any pattern) or just random pages?

[@vbalearningtutorials9758]

@@qualityassurancelab7764 suppose i have a multiples of url and i want to use loop in url.

[@vbalearningtutorials9758]

I want to extract pattern based data but from multiples url

[@AbhishekSingh-hb9vb]

Can we update values through rest command

[@qualityassurancelab7764]

Yes, using Patch action

[@AbhishekSingh-hb9vb]

@@qualityassurancelab7764 I have smart sheet api but I get response in JSON...Can not do read and write action. Could you please make a video how to use read and write JSON using REST

[@qualityassurancelab7764]

@@AbhishekSingh-hb9vb You can read the json actions of JSON Object Manager, I'll share the video soon

[@sebinjames8483]

Hi Ma'am, Thank you for the video. I've a question, is it possible to upload a document(pdf) using Post method, if yes, could you please help me with that?

[@davejuliant5550]

Hello mam, Can AA2019 Extracting data from Excel to a web form? please I have a task about this :) thank you before.

[@qualityassurancelab7764]

Yes, A2019 can do so. You can store data from Excel to Table Variable. Later on , take the help of table variable to put values on web form. To know how to work with Table Variable, please refer - kzbin.info/www/bejne/h6TZnmmFoaecb7c

[@02shailja]

Hi ma'am, Could you please make a video on SAP also

[@abdullahnjoum964]

For those who got an error that says there is no key called "body", Go to edit your variable, click on initialize values, add a key (call it body) and assign a "0" inital value and save changes then re-run your bot

[@qualityassurancelab7764]

Thanks for adding the details

[@abdullahnjoum964]

Greetings!

[@JI9131]

thanks

[@sandeepuniyal6817]

can you make a video to extract JSON Date by writing JavaScrip code.........

[@arjunreddy5110]

#How #to #pass #variables #from #one #task #to #another #task