Importing data into Excel using API

thompps — Tue, 01 Aug 2017 23:19:41 GMT

Hi, I hope you can help as I've spent hoursa trying to work out how to get data into Excel. I was initally excited when I saw there was sample code, but it uses outdated references to XP Web Services add-ins which I could no longer obtain.

So using webservice experience from before I tried to in the most simplest way just post the URL and expected to get data back, and that doesn't work either. I used the below to try and do something really simple:

https://www.methodintegration.com/MethodAPI/service.asmx?op=MethodAPITableListV2&strCompanyAccount=XXXX&strLogin=XXXXXX&strPassword=XXXX&strSessionID=XXXXXXX&strTable=Customer

I replaced all the XXX's with the correct fields of course! :) However, all it does is return me to the POST screen where I can enter details in the boxes and invokke it rather than using the data to generate a response.

So I can't even get simple data out without using the tools on the API pages. Can you steer me in the right direction here please? It would be really helpful if you have up to date info or demo's I can use in Excel 16. I just need a worksheet with RecordID and Fullname fields from the Customer table.

thanks

Peter

Search results by user ID 12928

Importing data into Excel using API