Box Data Source

 

About

The Box Data Source retrieves data from a file in a Box account. This data can then be used to populate a list of options in dropdown or radiobutton questions.

Data sources are usually set up to fetch data on a specified schedule.  This allows teams to maintain and update their data through the external service of their choice, minimizing the need to access the web portal.  

carlo_damico-box.png

Box is a popular cloud-based storage service.  Box users can access, manage and share their content from various devices and locations.  This makes Box an ideal service for storing data from mobile forms.   Looking for two-way integration?  Read more about the ways ProntoForms can connect to Box.

Watch the video below for an overview of integrating Box with ProntoForms.

[ top ]

 

admin.pngnouser.pngnomobile.png

Set Up the Data Source

BoxDS.png

  1. Create the data source as described here.

  2. Select Box Data Source as the type.  

  3. Name the data source and optionally enter a Description.

  4. Set up the data source using the information below.

[ top ]

 

Data Retrieval and Format

Push updates to device after a fetch

If turned on, users will get a notification from the ProntoForms app after a fetch. It will prompt users to reconcile (send/receive or refresh).   This setting is recommended if it is important that users have the most up-to-date data.    

  • With "push updates" and an automatic fetch set up, some data sources send a notification for each fetch, whether or not the data source has new data.

  • If the fetch schedule is hourly, users may get notifications hourly even if the data has not changed.

  • Some users may find these notifications annoying or confusing.  Consider the fetch frequency carefully if notifications are enabled.  

retrieval_andformat.png

 

Fetch Schedule

Automatically fetch new data on a schedule:

  • If checked, data will be retrieved from Box at the Fetch Frequency interval.

    • Make sure that the team has a Problem Contact Email Address.  If a fetch is unsuccessful for any reason, this address will receive an  email with an error message and details.  Without this email, it may not be immediately clear that a fetch has failed.  

  • If unchecked, the data source will not be updated automatically.   To retrieve new data from Box, the data source will need to be manually updated through the "Fetch New Data" button in the web portal.

 

Fetch Frequency: 

Choose Hourly, Daily, Weekly or Monthly.  This is how often the data source will fetch new data from Box.

 

Fetch Timezone: 

This applies to all fetch frequency options except “Hourly.”  Data will be fetched at midnight in the chosen time zone.

[ top ]

 

Input Configuration

inputconfig.png

  • Choose a Data Format (CSV, XML, JSON, or Excel).  CSV is most commonly used.  

  • UTF-8 Encoded:  If the file to upload is saved with UTF-8 encoding, check this option (if you are not sure, leave this unchecked).

  • Trim Whitespace: This option will remove any space, tab, or other "whitespace" characters that may be present at the beginning or end of a data value.  This is recommended.

  • CSV Delimiter: This option is relevant only when uploading a CSV file.  When saving to delimited format from a spreadsheet application, comma is generally used as the separating character, but semi-colon may be used by some applications in some regions.

[ top ]

 

Box Connection

Connection Configuration

Set up  a Box Connection or use an existing connection. 

 

File Path

Enter the path to the file containing the data.  The file must be stored in a folder. 

  • Examples:
    • If the "datasource.csv" file is in a Box folder called Lists, enter "Lists/filename.csv"
    • If the file "datasource.csv" is in Box at Lists/Customer/Data Sources, then the file path is "Lists/Customer/Data Sources/datasource.csv".
    • If the file "datasource.csv" is not in a folder, the data fetch will fail.
    • For example, in the below image, the file path for R1 Customer List is, "ProntoForms/Data Sources/Customer Lists/R1 Customer List".

      Box_Filepath_w_Files.png

      2015-12-18-BoxSheetPath.png

[ top ]

 

Fill the Source Data immediately:

fillsource.png

  •  If left unchecked, the data source will wait until the specified time and interval to retrieve data for the first time.
  •  If checked, data will be retrieved immediately after creating the data source.

[ top ]

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments