Export AppBuilder Cloud Data

[Matthew]

Is there a good/reliable way to export tens of thousands of rows of data from AppBuilder's cloud data?  My understanding is it's a MongoDB backend but available only thru an everlive restful api.

If it was MySQL or SQL Server we'd simply remote connect and use one of the many tools out there.

Running a restful query in the browser/fiddler etc. doesn't seem efficient.

I can't see any information on how to backup the database/data for offline use either.

Thanks!

[Lyubomir Dokov]

Hello Matthew,

For data management you can use the web based management portal. You can export the data in a content type as an XML file from the data browser too.

Currently the only way to programmatically process your data is through the RESTful API (you do not have an access on a database level). Of course, you could use one of the Telerik Backend Services SDKs, they wrap the RESTful API and make it available in a way native to your platform of choice.

If you have tens of thousands of items, you could use our paging functionality so that you can process the items in smaller parts and keep some kind of progress. You can read more about paging here. If you are using the JS SDK, the documentation for paging is located here.

As for offline support, our JS SDK provides it out of the box. It comes with built-in conflict resolution, synchronization and more. You can read more about it here. We do not support offline scenarios with the other SDKs at present, but it is possible to implement it yourself.

In addition, through the Data Connectors feature in Backend Services you can easily connect your on-premises relational database servers and expose the data from it via the Backend Services REST API. At the same time the data will be available only on your premises and manageable with the SQL tools you are used to working with.

May I ask you with what scenario and with which data operations you encountered any impediments?

Let me know if you have any other questions.


Regards,
Lyubomir Dokov
Telerik

 

 

[Matthew]

Thank you - very helpful!

 To clarify - I don't see anything in platform.telerik.com that allows for manual export: "You can export the data in a content type as an XML file from the data browser too."

Data Connectors is a great feature but my understanding is that's available with a "Telerik Platform
Enterprise" license only.

[Lyubomir Dokov]

Hello Matthew,

You are correct, seems that the functionality for exporting data from the portal has been removed. Sorry about that. In case you need the data as XML, you can do it like this:

http://api.everlive.com/v1/{your-api-key}/{content-type-name}?responseContentType=xml

Yes, the Data Connectors feature is only available in the Enterprise edition of Telerik Platform.


Let me know if you need any additional information.


Regards,
Lyubomir Dokov
Telerik

 

 

[Sairaj]

The URL you mentioned to use to get the XML data didn't work for me

[Anton Dobrev]

@Sairaj

The endpoint is functioning as expected, please make sure to replace the {your-api-key} and {content-type-name} placeholders for the actual Telerik Platform App Id and content type name. The URL should look similar to:

 https://api.everlive.com/v1/0Eja1m8ao6o/Activities?responseContentType=xml

Please note that it may be far more convenient to use the data in JSON format by calling the  endpoint with the general endpoint like:

 https://api.everlive.com/v1/0Eja1m8ao6o/Activities

The XML response will not preserve some types of the entered data and this may cause serialization discrepancies/problems.

Let me know if this works for you.

Regards,
Anton Dobrev
Telerik by Progress