Posting a REST API call from Excel (2010) (Excel VBA) and JSON

[anilga...@gmail.com]

Hi, 

We are working on a project , where we need to post a REST API call from Excel (2010) , which a posts a JSON array.

Could you please help with any pointers or useful links.

Thanks,

Anil

[Bruce Mcpherson]

There are plenty of examples here. 

http://ramblings.mcpher.com/Home/excelquirks/json

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[anil gangadharan]

Hi, Thanks for your quick reply. But apart from GAS, can we create the JSON from excel and post it to a RestAPI in Excel 2010 ?

Thanks in advance,

Regards,

Anil

--
You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/LCuoeYFNAHg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to excel-ramblin...@googlegroups.com.

[Bruce Mcpherson]

Yes .. all the examples in the link I sent you are Excel/VBA - not GAS

[anil gangadharan]

But when I have declared  this way it was throwing me compilation error , I am from a Java world , so couldnt find the root cause why it failed :(

Public Sub testcJobject1()

    Dim job As cJobject

    Set job = New cJobject




End Sub


[Bruce Mcpherson]

are you doing this on an empty workbook? or did you downloads the libraries? These classes do not exist in native VBA. You need to download cdataset.xlsm or emptycdataset.xlsm to start with and modify that