☰
Login
Signup
Home
›
.Net / VBA / Excel (3rd party)
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Categories
Recent Discussions
Activity
Categories
14.9K
All Categories
0
Incidents
174
Node JS client
50
Go client
835
.Net API client
396
Kite Publisher
554
.Net / VBA / Excel (3rd party)
486
Algorithms and Strategies
1.1K
Java client
1.2K
API clients
409
PHP client
4.3K
Python client
357
Mobile and Desktop apps
1.5K
Market data (WebSockets)
3.6K
General
Login error
umamaheswaran
August 2018
in
.Net / VBA / Excel (3rd party)
I tried below VBA code and it is giving me "Missing or bad request parameters or values" error. Is my URL conversion from API document is valid?
Sub doLogin()
Dim api As String, requestToken As String, checksum As String, fullData As String, URL As String, jsonData As String
Dim JSON As Object
api = ThisWorkbook.Sheets("Login").Range("B1").Value
requestToken = ThisWorkbook.Sheets("Login").Range("B2").Value
checksum = ThisWorkbook.Sheets("Login").Range("B4").Value
URL = "
https://api.kite.trade/session/token
"
fullData = "X-Kite-Version: 3" & "api_key=" & api & "request_token=" & requestToken & "checksum=" & checksum
'
jsonData = CallPostMethod(URL, fullData)
MsgBox jsonData
Set JSON = JsonConverter.ParseJson(jsonData)
End Sub
Sign In
or
Register
to comment.