Remote Lookup - BETA

(This is an advanced topic and will require some coding knowledge)

Remote Lookup allows you to remotely access lookup data from the device using a service you set up. You will specify an HTTP Url that will return the Lookup data based on the specified search criteria.

Note: Remote lookup will not work in the Web App or in Preview mode.

SET UP

• To start, open your form in the web builder and go to "Advanced Options" then choose "Lookup Mappings".

• Create a new mapping and choose "Remote Lookup Access" as the lookup type.

• You will need to enter the HTTP Url to which JSON search criteria will be Posted. This call will also result in the return of the matching lookup result.

• You have the option to use basic username/password authentication as well as token-based authentication. If you wish to do so, click the relative checkbox and enter your information. 

• Next, choose the fields on the form which will be passed via the Remote Url call to be used to search for the speciically requested Lookup Data record. Allowable field types are List Selector, Global List Selector, Lookup List Selector, Static Text, Bar Code Reader and NFC Reader.

TESTING

Here is a sample of the JSON that will be posted to the URL you specified. This will be sent via an HTTP POST call and we recommend that you employ SSL (HTTPS) when making the call. If username and password are provided they will be included in the authorization portion of the call. The format of this JSON is correct, but the content in this example is not. But you can use it to test our service.

The JSON posted to your URL

{
"mappingName": "Flowers",
"searchMappings": [
{
"searchField": "lookuplistpicker_1",
"searchValue": "testdata1"
}
]
}

The following is an example of the expected JSON format to be returned by your service from our POST to you. The basic concept is that you will return one record containing a list of Field Keys and the associated value. You will need to ensure the field key you send back exists in the form or it will be ignored.

The JSON returned by your URL

{
"mappingName": "Flowers",
"resultMappings": [
{
"fieldKey": "field_1",
"value": "Test Data"
},
{
"fieldKey": "field_2",
"value": "More Test Data"
}
]
}

Mapping

The display of the resulting call will be handled by the application. When the result of the call is returned, any returned values will be mapped to the Form, with the Field Key being used to map the value.