Trouble with VBA-JSON
Hello All,
It's been quite a minute since I've touched VBA and now I'm working with JSON, which is new to me. I'm trying to use this JSON Conversion utility, but I'm running into an error. I'm not sure where to start messing with their code, but I have a feeling it's relatively simple to correct. I've included some screenshots that may help. I don't know what else I'd need for you all, but would be happy to share it.
Thanks,
stu
2017-10-03_1320.png
2017-10-03_1323.png
2017-10-03_1324.png
Okay, I got to thinking about it and remembered I need credentials. So I added them and now get a different error, but seems to get further than before.
Now the debugger goes to:
This makes me think it's how I'm trying to call the field ("projects").
MsgBox Json("projects")
Thanks for any help!
2017-10-03_1336.png
I didn't have it formatted correctly, should have been:
MasgBox Json("projects")(1)
Hello stusic,
What is your actual objective? Could you please explain what you are trying to achieve with your project Workbook, before even applying an add in like "Jason"?
IMHO, I don't think Forum Members would be interested in down loading "Jason" to try and assist.
Please attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Winon,
The OP was trying to parse data in to excel using a third-party utility. There is no JSON parser built-in in VBA. You probably are aware that JSON has become very popular data exchange format. It is the preferred data format by many applications and is gradually taken over XML in terms of popularity. VBA has XML parser object. If you want to extract data, mainly from a web and that data format is JSON, you can use a JSON parser to convert the data from JSON format in to excel.
Some people have written a JSON parser for VBA. I think the guy name is Tim Hall (GitHub). I used his code in some of my project. It appears that his original work being converted in to some kind of utility.
Last edited by AB33; 10-03-2017 at 04:34 PM.
@ AB33,
Thank you for the clarification, I truly appreciate it.
Looks like something absolutely worth exploring.
Kind Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks