Creating an *.JSON file from an EM server

[Kathy L]

I can do an export of my data to an *.csv file but I need to provide a third party with an *.JSON file.

We are trying to do integration with an aggregator for our stores.

Can anyone tell me how I can get a JSON file from my server?

Thanks so much!

 

[codexPOSed]

You can run this in Sybase Interactive SQL:

SELECT * FROM "micros"."emp_class_def"
for json raw;
OUTPUT TO 'c:\temp\employee_classes.txt';

alternatively you can convert your csv files to json using an online service like this one:

https://csvjson.com/

 

[Kathy L]

Great thanks so much!