Welcome, Guest Login

Support Center

Process RSS, XML, JSON as a SQL DB

Last Updated: Dec 07, 2015 01:39PM EST
Introduction

The first part of this Tutorial shows how to connect a 3rd party data source (RSS, XML, JSON) into EachScape to make it available for your apps.
It is identical for every data source.


The we sho you how to process your data source so it is stored as an On Device SQL Database 
Learn the difference between SQL DB and Live Feeds.

Video Tutorial
For a video tutorial, check the RSS Feed Reader Tutorial

Choose a Data Source

Connect Data Source into EachScape
Go to the "Connect" tab.


Click on "New Source".


Here we want to configure a 3rd party Data Source, choose 'Data Feed'
 
 
In this tutorial, we use the Data Feed to create an on device SQL Database.
 
 
On Device SQL Database
Select On Device SQL DB
 
When you select On Device SQL, your data source will be processed by EachScape server and turned into a SQL lite DB sent to you device. Learn more about Data Architecture 

If you have your own feed use it, otherwise we can use this BBC data feed: http://feeds.bbci.co.uk/news/rss.xml
 
Give your Data Source a name, in our example we named it  "BBC News in SQL DB"
Paste the restful URL of your RSS, XML or JSON feed in the "URL" field.
 
 
Scroll down to where it says "Data Descriptor", you will see how the result of the parsing:
EachScape automatically parse your feed and show you the fields in the Data Descriptor.
 
Data Descriptor remains empty?
Check that you are using a standard feed structure.

Expert Users can Edit the Data Descriptor
 
Once you've configured your data source you can save it by scrolling down to where it says "Create" and this will save your data source in the Workspace that it was created in.
 



You will see the result of the processing of the data source.
That data source is now available as a SQL Lite Database and it will be shipped to the device.
 
You can learn how to configure your SQL DB in SQL DB settings
 



The Datasource turned into a DB shows in your Data Source list with the following orange icon:
 

You can now associate the On Device SQL Database  to your app by going to your app/apps in the "Apps" tab and click in the Navigation Panel on the left side of the builder where it says "add/remove data source".
 

Learn more

- SQL DB settings
Data Architecture
RSS Feed Reader 
Browsing a Live Feed (remote data source)
Use Cloud Collection as a Data Source
 

Help us improve! Rate this article:

Yes I found this article helpful

Ask a Question   

support@eachscape.com
http://assets0.desk.com/
false
eachscape
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete