VBA to call Toggl (web) API

$10-30 AUD

Completed

Posted

almost 8 years ago

$10-30 AUD

Paid on delivery

Hi all. I have a [login to view URL] account I use for time tracking, and I have an Excel spreadsheet for clients, projects, and invoicing. At this stage I'd just like someone to work out the correct VBA code to authenticate against Toggl. Here's the code I have: Sub togglTest() TargetURL = "[login to view URL]" Set HTTPReq = CreateObject("WinHttp.WinHttpRequest.5.1") [login to view URL](4) = 13056 [login to view URL] "GET", TargetURL, False [login to view URL] "api_token", "xxx", 0 [login to view URL] "Content-Type", "application/json" [login to view URL] "Accept", "application/json" [login to view URL] "x-user", "api_token" [login to view URL] "Authorization", "Basic " + Base64Encode("api_token:xxx") [login to view URL] MsgBox ([login to view URL]) End Sub I want to use the Toggl Reporting API which you can read about at [login to view URL] As per that document, we should be able to use Basic authentication and pass the string "api_token" as the username, and the actual API token as the password. The response from the above code is that I haven't sent the API token. There'll probably be some follow-up work, but for now I'm just after someone to fix the above code so it authenticates successfully.

Excel

Programming

Visual Basic for Apps

Project ID: 10577135

About the project

1 proposal

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@marekw63

Hi, this is fun! I have used VBA to authenticate to Xero via XLwings. I would strongly recommend you have a look at [login to view URL] Mostly because I found similar issues- VBA using 16 bit strings, new lines etc etc which make it trickier than you think. I am happy to help but you will need to stay involved! First let's prove curl works per the docs. Ie no VBA. Then call a 'localhost just to see what the string VBA is driving out. Let me know but will be in and out this week. If you assign the project happy to get going and send you results. Best regards Mark

$30 AUD in 3 days