[WD23] - Consuming JSON

Hi All

I can get a JSON feed of data from a supplier. They can also provide it in other formats but the JSON is ready to go now. Is WinDev a good tool for reading and processing a JSON feed?

Thanks

Hi JP

sure... just look in the help at json and search for json on this forum for examples

Just be aware that json functions are not at the same level in all environments (or were not, the last time I checked), so depending on which version and which tool, your milage may vary.

Best regards

Hi ,

Depends on the json format. If it is not what windev or webdev expects then it is a pain in you back-end .

webdev has cool features for using third party controls etc. But for instance you cannot use controls from syncfusion. Because syncfusion doesnot recognize the webdev json. The json string starts with a space and that is funest.

It is a pitty for if it would work then wow we had a webdev with more controls then windev.
So try and if it works ok . IF not then maybe sent pcsoft a support mail.

R

Thanks Fabrice and wduser. Will check it out !

One I got the hang of it I've had great luck working with JSON in windev both creating and consuming. Way easier than XML IMO

JSONToVariant and VariantToJSON are a great place to start.



Edited 1 time(s). Last edit at 08/02/2018 11:41PM by steve erts.

steve erts Wrote:
-------------------------------------------------------
> One I got the hang of it I've had great luck
> working with JSON in windev both creating and
> consuming. Way easier than XML IMO
>
> JSONToVariant and VariantToJSON are a great
> t place to start.


Hello,

Thanks a lot. Your comments got me started on JSON in a very easy way. I cannot believe it is this easy to use JSON.

But I have one problem.

How to send JSON to remote service?

--
Yogi Yang

Hello,

Solved the problem by using following code:

req is httpRequest

req..URL = sURL
req..Method = httpPost
req..ContentType = "application/json"
req..Content = VariantToJSON(JZ)

HTTPresponse is httpResponse = HTTPSend(req)

TIA

--
Yogi Yang