1- Overview
This guide provides an overview for importing external data into the InReality platform.
Topics reviewed in this guide include:
- Data Formats Supported
- Data Format Requirements
- Data Log Types
- Using the InReality Platform to:
- Create a Datasource
- Map data fields and configure data types and datapoints
- Uploading External Data through Restful API
2- Data Format
Data Format Type: CSV
Comma Separated Values (CSV): CSV files are commonly used for data exchange between platforms, making the data “raw” again so it can be processed by different applications. This is the most flexible data format.Comma Separated Values (CSV): CSV files are commonly used for data exchange between platforms, making the data “raw” again so it can be processed by different applications. This is the most flexible data format.
Data Format Requirements
The first row must contain a header row with a descriptive title. This will be used for mapping key data used in the analytics and insight reports.
Data Log Types
- Event Logs - This is a log for the events with unique identifiers and dwell time.
- Example - footfall count
- Action Logs - This is a log for the actions without any dwell time.
- Example - touch interaction logs on a kiosk display
3- InReality Platform
- Login to the InReality Platform and add a new datasource in the ‘External Data’ section, as shown below.
- Upload sample data and then map the fields, data type, values and datapoints.
- The InReality Platform will generate an end-point URL and API key for posting the data.
- Data point values that are supported : String, number, date,
- Select the data points (to use in formula, both data points to be summarized and breakdown)
- Select the field in the data file that the system will use to group the events (e.g., group by UNIQUE_ID field in the data)
- Select the Store/Venue and AOI (Area of Interest) mapping field, needed to allow the user to map the values into a data file to the store/AOI
- Select if the data point would be available under which AOI in the formula page
- Define and provide date and time format.. If time is not defined, follow time in date field
Data Details

Data Mapping

Venue Mapping
AOI Mapping
Upload Data

4- Upload External Data - RESTful API
External data in the supported formats can be uploaded to the InReality Platform’s Data Lake through the Restful API.
# External data API Usage
curl -X POST -F 'file=@filename' https://api.inreality.com/v3/data/thirdparty/pos?api_key=YOUR-API-KEY
curl -X POST -F 'file=@filename' \
https://api.inreality.com/v3.1/data/thirdparty/custom/MY-DATA-ID?api_key=your-api-key
### Sample Usage (CURL)
curl -X POST -F 'file=@~/Documents/data.csv' \ https://api.inreality.com/v3.1/data/thirdparty/custom/MY-DATA-ID?api_key=your-api-key
```
### Options
##### key (required)
API authentication
##### file (required)
filename

