Is it possible to return JSON using sData?

[chadcrabb]

I have been working with sData for a while now in XML format, but would prefer to get JSON data back instead.  According to the sData spec this is possible by passing a format=json.  Does this work for SalesLogix?  Does anyone have experience with this?

[mvolpe]

Hi,

I also need to return JSON using sData, how can accomplish that ?

Thanks,

Marcelo.

[garnold]

What version of SLX are you working with? SP3 does return JSON. In fact this is the default format for the return.

[mvolpe]

Hi Gene,

I need to consume data from Slx 7.5.3 using SDATA, but I would like to get the objects based on Json format, the data is retrieved in feed format.

is there anything i need to set so that sdata returns a json object?

Thanks,

Marcelo.

[chadcrabb]

You need to sent a format=json at the end of the URL or add a header for Json.

[RJSamp]

Could you please post an example?

Thanks!

[chadcrabb]

http://<your server and port>/sdata/slx/dynamic/-/activities?format=json

[mvolpe]

Hi

I am using JScript to consume SData services? How can I enable Json ? within the create service constructor ?

Thanks,

Marcelo.

[chadcrabb]

 I'm not sure what library you are using. Can you provide your code?

[mvolpe]

Below is the code I am using to create the service, I am using sdata-client-dependencies.js and  sdata-client.js

function CreateService() {

var service = new Sage.SData.Client.SDataService({

serverName:'myserver',

port:'myport',

virtualDirectory:'sdata',

applicationName:'slx',

contractName:'dynamic',

userName:'lee',

password:''

                                                                                                         });

return service;

                                                          }