Skip to main content
asekar5-Regular Member
5-Regular Member
June 7, 2018
Solved

Export to csv through service

I have a Thing and valuestream associated to that. Have made properties of that thing logged and persistent so that I can use valuestream for time series. I'm able to get the same in a mashup.

 

If I wanted to write a service which will perform the same function as an export widget in a mashup, I would be able to invoke service every x mins to export the property history to csv

 

Thanks in advance

mnarangAnswer
5-Regular Member
June 7, 2018

Or else you can try using the service "WriteCSVFile" from available snippet .It is like this -

var params = {
 path: undefined /* STRING */,
 data: undefined /* INFOTABLE */,
 fileRepository: undefined /* THINGNAME */,
 withHeader: undefined /* BOOLEAN */
};

// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

 

It takes data as an infotable which will be coming from the "QueryPropertyHistory" so you can pass that infotable to this service and write this to CSV in repository .

View in thread

3 replies

zyuan15-Regular Member
5-Regular Member
June 7, 2018

Hello, I think you could use the service in Data Export Extension, the entity it includes have service to help infotable exported as CSV file.

Translate
mnarang5-Regular MemberAnswer
5-Regular Member
June 7, 2018

Or else you can try using the service "WriteCSVFile" from available snippet .It is like this -

var params = {
 path: undefined /* STRING */,
 data: undefined /* INFOTABLE */,
 fileRepository: undefined /* THINGNAME */,
 withHeader: undefined /* BOOLEAN */
};

// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

 

It takes data as an infotable which will be coming from the "QueryPropertyHistory" so you can pass that infotable to this service and write this to CSV in repository .

Translate
    asekar5-Regular MemberAuthor
    5-Regular Member
    June 7, 2018

    Thank you. This worked

     

    Arvind

    Translate
    Terms & ConditionsAccessibility statement