Export AppBuilder Cloud Data

6 posts, 0 answers
  1. Matthew
    Matthew avatar
    3 posts
    Member since:
    Jul 2015

    Posted 09 Sep 2015 Link to this post

    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!

  2. Lyubomir Dokov
    Admin
    Lyubomir Dokov avatar
    43 posts

    Posted 10 Sep 2015 Link to this post

    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
     
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
     
  3. Matthew
    Matthew avatar
    3 posts
    Member since:
    Jul 2015

    Posted 14 Sep 2015 in reply to Lyubomir Dokov Link to this post

    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.

  4. Lyubomir Dokov
    Admin
    Lyubomir Dokov avatar
    43 posts

    Posted 15 Sep 2015 Link to this post

    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
     
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
     
  5. Sairaj
    Sairaj avatar
    10 posts
    Member since:
    Feb 2015

    Posted 16 Aug in reply to Lyubomir Dokov Link to this post

    The URL you mentioned to use to get the XML data didn't work for me
  6. Anton Dobrev
    Admin
    Anton Dobrev avatar
    539 posts

    Posted 18 Aug Link to this post

    @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
     
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
     
Back to Top