api

How do I download a file using VBA (without Internet Explorer)

by

This solution is based from this website: http://social.msdn.microsoft.com/Forums/en-US/bd0ee306-7bb5-4ce4-8341-edd9475f84ad/excel-2007-use-vba-to-download-save-csv-from-url It is slightly modified to overwrite existing file and to pass along login credentials. Sub DownloadFile() Dim myURL As String myURL = “https://YourWebSite.com/?your_query_parameters” Dim WinHttpReq As Object Set WinHttpReq = CreateObject(“Microsoft.XMLHTTP”) WinHttpReq.Open “GET”, myURL, False, “username”, “password” WinHttpReq.send If WinHttpReq.Status = 200 Then Set oStream = CreateObject(“ADODB.Stream”) … Read more

Do twitter access token expire?

by

Here is what they saying in there development page Question: How long does an access token last? Access tokens are not explicitly expired. An access token will be invalidated if a user explicitly revokes an application in the their Twitter account settings, or if Twitter suspends an application. If an application is suspended, there will … Read more

What public APIs are provided by Governments to the public?

by

Suddenly I feel proud to be a British Citizen… are you ready? Good: HMRC (the lovely people who take our tax off us) provide a fully documented API, see here, for filling in just about every form they have. Not only that, but they define a whole set of schemas and everything available here: http://www.cabinetoffice.gov.uk/govtalk/schemasstandards.aspx … Read more

Proper route for checking resource existence in a RESTful API [closed]

by

HEAD is the most effecient for existence checks: HEAD /users/{username} Request a user’s path, and return a 200 if they exist, or a 404 if they don’t. Mind you, you probably don’t want to be exposing endpoints that check email addresses. It opens a security and privacy hole. Usernames that are already publicly displayed around … Read more

Getting someone’s Steam inventory

by

New Endpoint There is a new end point for fetching inventories as of December 2016. The old one listed below still works (for now). Both seem to be highly ratelimited. The new inventory path is: http://steamcommunity.com/inventory/<PROFILEID>/440/2?l=english&count=5000 With this new path, l is the language you want to receive data back in and count is the … Read more

How to retrieve all tweets from a user and not just the first 3,200 as Twitter limits it’s timeline and API to

by

You can use twitter search page to bypass 3,200 limit. However you have to scroll down many times in the search results page. For example, I searched tweets from @beyinsiz_adam. This is the link of search results: https://twitter.com/search?q=from%3Abeyinsiz_adam&src=typd&f=realtime Now in order to scroll down many times, you can use the following javascript code. var myVar=setInterval(function(){myTimer()},1000); … Read more