Forms and Regions REST API
Overview
The Forms and Regions REST API services allow Customers the ability to get Form and Form Template information from the Field2Base system.
Base URL
https://fieldconnect.field2base.com/v2/api
Header (Required)
Authorization: Basic {CompanyID}:{Username}:{Password}:{API Sync Key}
Content-Type: application/json

Authorization Header above is the standard for all F2B REST API calls.
F2B API Prerequisites
To use the Devices REST API, you need the following:
- An API Sync Key for the Company
- A User Account with the ability to submit to the API (Mobile Forms Administrator role)
Supported Operations
The following operations are supported by the REST web service.
Devices
Endpoint
| Method
| Description
|
forms/
| GET
| get collection of form templates in company
|
forms/{folderKey}
| GET
| get collection of form templates in a given folder (folderKey = projectKey/ProjKey)
|
forms/regions/{formTemplateID}
| GET
| get collection of regions in a given form template
|
forms/region/options/{formTemplateID}/{DataSourceName guid}
| GET
| get possible datasource options
|
forms/region/options/{formTemplateID}/{DataSourceName guid}?parameters={parameter option}
| GET
| get results of executing a given datasource in a given form template if datasource uses parameters
|

Note: Be sure to add "/" at the end of the call if there is a period in the Username.
API Samples
Endpoint: forms/
Method: GET
Response:
- [
- {
- "TemplateId": "1dd66dcf-2ab2-40b0-8241-98bfdf5a6d84",
- "Name": "Inspection Sheet",
- "ProjKey": "ed02146a-2ca7-4ce7-980f-7f840ba3f568",
- "ProjName": "Sandbox (Ceara)",
- "Version": 27,
- "Description": "for home inspections"
- },
- {
- "TemplateId": "ba056acd-75f7-45b1-b5ab-1937aab8e411",
- "Name": "DVIR",
- "ProjKey": "3fec86e5-7069-41e4-966e-b3ad96ed1f8e",
- "ProjName": "Sandbox (Nick)",
- "Version": 1,
- "Description": ""
- },
- {
- "TemplateId": "1d5f3b89-ae47-4d1d-afae-5f6d5d9d233f",
- "Name": "F2B Statement of Work",
- "ProjKey": "0f4300b6-9548-4e7a-85d9-c53122626010",
- "ProjName": "Contracts",
- "Version": 4,
- "Description": ""
- },
- {
- "TemplateId": "2d1dfad1-9ae4-4990-a3e8-ba86bdb07b1f",
- "Name": "Sample Expense Report",
- "ProjKey": "1be2fd67-9c0b-40ba-a440-40a9c6fe0589",
- "ProjName": "Form Library",
- "Version": 23,
- "Description": ""
- },
- {
- "TemplateId": "e8bac552-3486-47ff-87ed-6cfaf3c1c0fb",
- "Name": "Sample Timesheet",
- "ProjKey": "1be2fd67-9c0b-40ba-a440-40a9c6fe0589",
- "ProjName": "Form Library",
- "Version": 2,
- "Description": ""
- }
- ]
Endpoint: forms/{folderKey (aka ProjKey)}
Method: GET
Example: forms/1be2fd67-9c0b-40ba-a440-40a9c6fe0589
Response:
- [
- {
- "TemplateId": "2d1dfad1-9ae4-4990-a3e8-ba86bdb07b1f",
- "Name": "Sample Expense Report",
- "ProjKey": "1be2fd67-9c0b-40ba-a440-40a9c6fe0589",
- "ProjName": "Form Library",
- "Version": 23.
- "Description": "for work expenses, has a workflow for approval then send to Payroll"
- },
- {
- "TemplateId": "e8bac552-3486-47ff-87ed-6cfaf3c1c0fb",
- "Name": "Sample Timesheet",
- "ProjKey": "1be2fd67-9c0b-40ba-a440-40a9c6fe0589",
- "ProjName": "Form Library",
- "Version": 2,
- "Description": ""
- },
- {
- "TemplateId": "e0646cf6-db54-4b59-86aa-ba4953f052b9",
- "Name": "Sample Work Order for Phone",
- "ProjKey": "1be2fd67-9c0b-40ba-a440-40a9c6fe0589",
- "ProjName": "Form Library",
- "Version": 5,
- "Description": ""
- }
- ]
Endpoint: forms/regions/{formTemplateID}
Method: GET
Example: forms/regions/2d1dfad1-9ae4-4990-a3e8-ba86bdb07b1f
Response:
- [
- {
- "Number": 1,
- "Name": "PageName1",
- "Description": "",
- "Title": "Page 1 Regions",
- "Regions": [
- {
- "FullName": "Page1@ApprovalSignDate",
- "DisplayName": "ApprovalSignDate",
- "Type": "Label",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@ApprovedBy",
- "DisplayName": "ApprovedBy",
- "Type": "Text",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": true,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@EmployeeName",
- "DisplayName": "EmployeeName",
- "Type": "Text",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": true,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@EmployeeSignDate",
- "DisplayName": "EmployeeSignDate",
- "Type": "Label",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@EndDate",
- "DisplayName": "EndDate",
- "Type": "Date",
- "DefaultValue": "",
- "DateTimeFormat": "M/d/yyyy",
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": "0002-01-01T00:00:00",
- "MaxDateValue": "9998-12-31T23:59:59.999",
- "IsRequired": true,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@MileageRate",
- "DisplayName": "MileageRate",
- "Type": "Numeric",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@ReportTitle",
- "DisplayName": "ReportTitle",
- "Type": "Text",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": true,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page1@StartDate",
- "DisplayName": "StartDate",
- "Type": "Date",
- "DefaultValue": "",
- "DateTimeFormat": "M/d/yyyy",
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": "0002-01-01T00:00:00",
- "MaxDateValue": "9998-12-31T23:59:59.999",
- "IsRequired": true,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- }
- ]
- },
- {
- "Number": 2,
- "Name": "Page2",
- "Description": "",
- "Title": "Page 2 Regions",
- "Regions": [
- {
- "FullName": "Page2@ExpenseCategory1",
- "DisplayName": "ExpenseCategory1",
- "Type": "Datasource",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": [
- "Airfare",
- "Hotel",
- "Meals",
- "Rental Car",
- "Transit / Ride Share",
- "Personal Vehicle",
- "Phone Bill"
- ],
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "7e9a57a3-dba3-41e0-aa43-ea38e3bc8827",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@ExpenseComments1",
- "DisplayName": "ExpenseComments1",
- "Type": "Text",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@ExpenseDate1",
- "DisplayName": "ExpenseDate1",
- "Type": "Date",
- "DefaultValue": "",
- "DateTimeFormat": "M/d/yyyy",
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": "0002-01-01T00:00:00",
- "MaxDateValue": "9998-12-31T23:59:59.999",
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@ExpensePhoto1",
- "DisplayName": "ExpensePhoto1",
- "Type": "Camera",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@ExpenseTotal1",
- "DisplayName": "ExpenseTotal1",
- "Type": "Numeric",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": 2,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@MilesDriven1",
- "DisplayName": "MilesDriven1",
- "Type": "Numeric",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "Mileage rate is automatically calculated at .58 per mile",
- "DataSourceName": "",
- "DataSourceParameters": []
- },
- {
- "FullName": "Page2@NoReceipt1",
- "DisplayName": "NoReceipt1",
- "Type": "Checkbox",
- "DefaultValue": "",
- "DateTimeFormat": null,
- "Options": null,
- "MaxTextLength": null,
- "MinDateValue": null,
- "MaxDateValue": null,
- "IsRequired": false,
- "DecimalPlaces": null,
- "MaxNumericValue": null,
- "MinNumericValue": null,
- "Formula": "",
- "UserCanOverride": false,
- "UserCanEdit": true,
- "ToolTip": "",
- "DataSourceName": "",
- "DataSourceParameters": []
- }
- ]
- }
- ]
Endpoint: forms/region/options/{formTemplateID}/{DataSourceName}
Method: GET
Example: forms/region/options/2d1dfad1-9ae4-4990-a3e8-ba86bdb07b1f/7e9a57a3-dba3-41e0-aa43-ea38e3bc8827
Response:
- [
- "Airfare",
- "Hotel",
- "Meals",
- "Rental Car",
- "Transit / Ride Share",
- "Personal Vehicle",
- "Phone Bill"
- ]
Endpoint: forms/region/options/{formTemplateID}/{DataSourceName}?parameters={parameter option}
Method: GET
This example assumes that we are using two regions, with Region 1 as a parameter for the Region 2 query. For this example, we will assume that the corresponding datafile contains an ExpenseCategory "Airfare" with a corresponding Rate of "$100".
Region 1: {
FullName: "Page2@ExpenseCategory1",
Type: "Datasource",
DataSourceName: "7e9a57a3-dba3-41e0-aa43-ea38e3bc8827"
}
Region 2: {
FullName: "Page2@Rate1",
Type: "Datasource",
DataSourceName: "1a2b3c4d-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
DataSourceParameters: [
"{Page2@ExpenseCategory1}"
]
}
Region 2 SQL Query:
SELECT [Rate]
FROM [SheetName$]
WHERE [ExpenseCategory] = ?
Parameters: {Page2@ExpenseCategory1}
Example: forms/region/options/2d1dfad1-9ae4-4990-a3e8-ba86bdb07b1f/1a2b3c4d-xxxx-xxxx-xxxx-xxxxxxxxxxxx?parameters=Airfare
Response:

Note: If you are using multiple parameters in a query, use the endpoint format: forms/region/options/{formTemplateID}/{DataSourceName}?parameters={parameter option}¶meters={parameter option}
Popular Articles
Forms Designer Quick Start Guide
Overview Field2Base Forms Designer is the proprietary software application that allows your existing Forms to be quickly converted to an active, online, smart Form available to your end users via our Mobile Device and Web-based Applications. This ...
Integration Service Configuration Guide
How To Configure Integration Services To Allow Read/Write Access on a Network Path All of our Integration Products, including the DIM, DUU, and EDM have respective Windows Services responsible for communicating with our server. Occassionally, ...
Data Integration Module (DIM) Migration Guide
Overview This article provides the information necessary to migrate the Field2Base Data Integration Module (DIM) over from one server to another. Please refer to the DIM Install Guide for the initial installation of the Field2Base DIM. Once that's ...
Mobile Forms iOS Enterprise App Upgrade to the Mobile Forms iOS App Store
Overview This guide will review how to switch between two versions of the Mobile Forms app, uninstalling the Enterprise build and installing the App Store Build. The primary benefits of switching over are that updates to the App Store build are ...
How to Check the Version of Integration Products Running on a Windows 10 Machine
Right-click on the Start menu button. Click on Apps & Features. In the Apps & Features search bar type in the Integration Product you are looking for, eg. F2B Data Integration Module, F2B Data Upload, or F2B Enterprise Dispatch Module. Click to ...