On Tue, Jul 11, 2017 at 1:31 PM, Sajith Abeywardhana <sajith...@gmail.com> wrote:
> Hi Team, > > Is there any way that I can export the data to the CSV format from the > given table? I used the APIs[1] but it won't gives me a total number of > records as a result. When I looked from the data explorer it shows more > than 100000 records but APIs gives me only 7000+ records. > > AFAIK, you have used the correct API, I have tried with few records and it worked fine.. Whether you have encountered above situation when there are large number of events ? Hope there is no any connection timeout with the server when executing above request. @Gimanatha, can you please provide your input on this. Thanks, Mohan > > [1]. > curl -X POST -H "Content-Type: application/json" -H "Authorization: Basic > YWRtaW46YWRtaW4=" https://10.0.4.42:9443/analy tics/search_count -d > '{"tableName":"SENSOR_EVENT_DATA_STREAM"}' -k > > curl -k -X POST https://10.0.4.42:9443/analytics/search -H > 'authorization: Basic YWRtaW46YWRtaW4=' -H 'cache-contr ol: no-cache' > -H 'content-type: application/json' -H 'postman-token: > 96b4b45b-dcae-841b-40ed-0e6e1f12d36b' -d '{ > "tableName":"SENSOR_EVENT_DATA_STREAM", > "start":0, > "count":1000000 > }' >> das1-data.json > > Thanks, > Sajith. > -- *V. Mohanadarshan* *Associate Tech Lead,* *Data Technologies Team,* *WSO2, Inc. http://wso2.com <http://wso2.com> * *lean.enterprise.middleware.* email: mo...@wso2.com phone:(+94) 771117673
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev