I need a simple vbscript (a vbs file will be generated) code that parses the json return from an API. I have the code that sends the request to the API and gets the response (this code can be provided). I only need the code that parses the json returned by the API and make it available. I need to know the content of each field from the json, and when each record starts and ends, so that each record can be stored in a database (database store code not needed for this project). The json model schema is like so:
{
"name": string
"id": int
"birth": date
}
If you have your own jason parsing library, it can be useful. I am using this: [login to view URL] (it can be provided).
The code I have so far is like this:
set objHTTP = [login to view URL]("[login to view URL]")
[login to view URL] "GET", "http://localhost/website/[login to view URL]", false
'Some headers:
[login to view URL] "CustomerAccountId", "{my_account_id}"
[login to view URL] "CustomerId", "{my_customer_id}"
[login to view URL] "DeveloperToken", "{my_API_access_Key}"
[login to view URL] "Password", "{my_password}"
[login to view URL] "UserName", "{my_user_name}"
[login to view URL] ""
'Error treatment:
If [login to view URL] >= 400 And [login to view URL] <= 599 Then
[login to view URL] "Error Occurred : " & [login to view URL] & " - " & [login to view URL]
[login to view URL]
Else
[login to view URL] "Success : " & [login to view URL] & " - " & [login to view URL]
[login to view URL]
End If
str = [login to view URL]
set o = [login to view URL](str)
'I need the rest of the code here!
Hi,
I have 15+ years of experience. What I will do is, will parse the value and assign to the variable, so that it can be use to insert in the table.
I am available now and do it right away.
Thanks
$77 USD w 1 dzień
4,8 (212 opinii)
7,6
7,6
4 freelancerzy składają oferty o średniej wysokości $155 USD dla tej pracy
Hi Claudiohz,
I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements and we can move forward to the next step.
Thanks,
Joseph C Ocero