JSON Documents
Contents
About
Output data from your submitted forms in a JSON format, perfect for integration with your backend system. There are different options for structuring and customizing your JSON format.
JSON documents can be sent to cloud and enterprise services, web services, and more. A number of document types are available, and multiple documents can be sent with a single form submission.
Note:If 
A Unique ID refers to the specific identifier of a question, form page, form section, or Data Destination. Unique IDs are used as reference points when pulling data for conditional logic, Analytics projects, Data Destinations, and Documents. and not the question text.
Settings
Create a Document
Documents are created in the Web Portal, not the Form Builder. To create a document:
-
Hover over Manage Forms, and then select Documents.
-
From the Documents page, select Create Document.
-
Choose a document type.
-
Fill out the details required for your document type.
Document Basics
Name/Description
Give the document a unique name. Optionally provide a description.
Filename
This name applies to all instances of the document, including downloaded documents and documents sent by Data Destinations.
You download files from multiple form submissions so that you can work locally.
You or your customers receive multiple messages generated by Email Destinations.
- Use Data Reference Expression Language to reference answers in your forms.
- Static text can also be included.
- For example, %r -- %a[Customer Name] would name the file like "20140812-180001002 -- John Smith."
- Some data destinations will overwrite files with duplicate names. Make sure file names are unique by including one or more of:
- %r - the submission's reference number -- e.g. 20140920-1815562464
- %r[id] - the submission's ID - e.g. 1815562464
- %t - the time the form was submitted
Document Timezone Source
Choose a document time zone source. This is the time zone for all dates and times in your document.
- Team Preference Setting: Will use the time zone chosen for the team
- Data Record: Will use the time zone the form submission is made from (as chosen on the mobile device).
- Custom: Choose a time zone.
Auto-Link new forms to this document
Selecting this option will add the document as an "Additional Document" to forms created or imported after this option is set. Submissions made against these forms will be downloadable in this document format from the "Data" tab of the portal.
JSON Document Configuration
Form Model Version
We currently support v2 forms only. You don’t need to change this setting.
Embed attachments within the Data Record Document
This will include the attachment "bytes" property, which is necessary if you need to use the images collected at any point.
Data Node Format
This setting changes how the nodes containing question/answer information are named.
- Standard: Uses generic, standardized node names for page, section, and question nodes.
- Question Labels as Node Names: Uses the question label in place of the generic question/answer node name.
- All Labels as Node Names: Uses the page, section, and question labels in place of the generic page, section, and question node names.
For more details on these options, please read: Form Submission Formats: Standard vs. Labels as Node Names.
Image Compression Ratio
Enter a value between 0 and 1 to compress images embedded in this document. Compression will reduce the size of the document, at the cost of image quality. 0 is completely compressed, 1 is no compression.
Wrapping JSON Options
If your downstream service requires that JSON documents be wrapped in either a JSON object or array, select the appropriate option. You may need to use this option if the endpoint is not built by you, and may have requirements for the incoming data that TrueContext does not adhere to without these wrappers. An example of this is the Salesforce Apex REST Data Destination.
Example Wrapped Outputs
JSON Object = on, JSON Array = off
"<JSON Object Name>" : {
{ <data record json> }
}
JSON Object = off, JSON Array = on
[
{ <data record json> }
]
JSON Object = on, JSON Array = on
"<JSON Object Name>" : { [
{ <data record json> }
] }
JSON Object = off, JSON Array = off
{ <data record json> }
When set up is complete, select Create. Link the document to a form in order to use it.
JSON Document Samples
The following examples show the structure of Regular and Repeatable Section A Repeatable Section is a subform that contains a set of related questions. The data captured is “repeating”, because the field user can complete the same subform more than once, which creates multiple entries. data and metadata in a JSON document.
For TrueContext REST APIs and JSON/XML document formats, we maintain a practice of not deleting existing properties or objects. A mechanism for versioning is used to facilitate deletions to our JSON/XML formats when necessary. Customers will be contacted in advance if they will be affected.
We will occasionally, however, add new properties to existing APIs to support new features in the TrueContext Platform. We do not create a new version of our APIs for new properties, and we advise that clients of our APIs are resilient to additions by ignoring unknown properties. Client applications should ignore any properties that are not relevant to their use case.
JSON example of a Regular Section
This JSON example contains data and metadata from a Regular Section A Regular Section is a set of related questions grouped together for easy reference. The data captured is “non-repeating”. That is, field users enter a single instance of each answer., referred to in the JSON as type “Flow”.
"pages": [{
"label": "LI",
"name": "Labor Information",
"sections": [{
"type": "Flow",
"label": "WP",
"name": "Work Performed",
"answers": [{
"label": "DescWork",
"dataType": "FreeText",
"question": "Description of Work",
"values": ["This is another test description."]
},
{
"label": "Comments",
"dataType": "FreeText",
"question": "Comment(s)",
"values": ["This is another test comment. "]
},
{
"label": "PoI",
"dataType": "Image",
"question": "Photos/Sketch of Interest",
"values": [{
"identifier": "7da58b3b-cb3e-4895-8b8e-a9a3f6bc9f9f",
"filename": "PoI_1.jpg",
"contentType": "image/jpg"
}]
}]
}]
JSON example of a Repeatable Section
This JSON example contains data and metadata from a Repeatable Section, referred to in the JSON as type “Repeat”.
"pages": [{
"label": "Job Information",
"name": "Job Information",
"sections": [{
"type": "Repeat",
"label": "Equipment details",
"name": "Collect details about equipment",
"rows": [{
"pages": [{
"label": "ED",
"name": "Equipment Details",
"sections": [{
"type": "Flow",
"label": "New Section 3",
"name": "null",
"answers": [{
"label": "Make",
"dataType": "FreeText",
"question": "Make",
"values": ["Equipment Make 4"]
},
{
"label": "Model",
"dataType": "FreeText",
"question": "Model",
"values": ["4A"]
},
]
}]
}{
"label": "ED",
"name": "Equipment Details",
"sections": [{
"type": "Flow",
"label": "New Section 3",
"name": "null",
"answers": [{
"label": "Make",
"dataType": "FreeText",
"question": "Make",
"values": ["Equipment Make 3"]
},
{
"label": "Model",
"dataType": "FreeText",
"question": "Model",
"values": ["2A"]
},
]
}]
}]
}]
"footer": {
"answers": []
}
}]