PDA

View Full Version : Problem about data form excel to API



thanhvanchi
12-04-2016, 01:39 AM
Hello everyone!

I'll be more than happy if you can help me with this issue.
Today I'm using chrome extension "POSTMAN" when I'm sending API leads to Brand's CRM I'm sending API http post\get one by one.
In "POSTMAN" or any other http rest you can't send more then 1 request at a time (correct me if I'm wrong)
How can I send a few API http requests from excel file in VBA or is there an easy way to do that?(I know i shuold use XMLHTTP in VBA but i dont know how to to it.)
I need to send data form excel to API with user name and password + mendetory fields in http post\get.
Please help me with an example of code in VBA for this issue.
Hope my explanation was understand.
Thanks again.

Kenneth Hobs
12-04-2016, 05:45 PM
I have not used those. I have used winhttprequest. e.g. http://www.vbaexpress.com/forum/showthread.php?25616-Download-a-txt-file-from-Website-using-excel