Choose a topic:
The mappings branch is where the actual field mapping happens. All the entities that should be exported need to appear in this branch as well. Every entity has its own mapping. An empty mapping could look like this (the entity names may vary, depending on the CRM):
Every CRM field that is listed in the mappings branch receives the data that is defined between the brackets "{{ }}" (* There are more advanced ways too). The fieldMapping looks like this:
The whole entity mapping looks like this:
Syntax | Example |
---|---|
"{{ }}" either contains:
Syntax | Example | Explanation | |
---|---|---|---|
Empty | "{{ }}" | "{{ }}" | Nothing (null) is set |
Default Value | "{{ 'DefaultValue' }}" | "{{ 'Exhibitions' }}" | Sets the entered value |
snapADDY variable | "{{ variable }}" | "{{ firstName }}" | Sets the value of the default field There's a list of all default fields |
Predefined Function | "{{ functionX(arg) }}" | "{{ parseStreet(street).number }}" | Executes the function and sets its return value. Note: function must be defined in the "code" branch |
question response | "{{ _answers['id'] }}" | "{{ _answers['xOa9VA3JZd6b2qlv'] }}" | Sets the response of the VR question with the id. _answers[] will return null, if the question does not have an answer. This behaves like an empty mapping |
Multiple values can be chained together by using logic operators.
Operator | Syntax | Example | Explanation |
---|---|---|---|
OR | || | "{{ value1 || value2 }}" | value1 or value2 |
AND | && | "{{ value1 && value2 }}" | value1 and value2 |
_answers['questionId'] is an internal function that allows to retrieve the result answer(s) of a snapADDY VisitReport question. You can read how to receive the question ids below. If a question has multiple selected options, the values of each result are concatenated using a semicolon. If no explicit value was set for the answer options, snapADDY returns the label of the option. It is recommended to use the value rather than the label in the mapping, in order to avoid errors when the labels are changed afterwards. A question that is not filled or selected will return null. The questionId is case sensitive! "visitreport." offers more variables from the visitReport.
visitReport.result['questionId'].data has the same behaviour as _answers['questionId']. visitreport.result['questionId'].options['optionId'] allows to query a specific option. A full list of commands can be seen here: )
The questions ids can be copied from the mapping helper. Follow these steps:
- Download and open the mapping helper
- Enter your API Key (can be found here) and press Load
- Select the correct VisitReport
- Search for your question. If you can't find it, it's either the wrong visitReport or the question is not part of the visitReport yet.
- Copy the MappingId (not the ID) and paste it in _answers['id']
Checklist for field mapping
- Is the field contained in the corresponding entity in fieldDefinitions (case-sensitive! It`s best to always copy and paste complex names!)
- Is the field creatable/updatable/?
- Does the datatype match?
- Make sure to not include commas "," in strings, since this character is used internally and this might cause unexpected errors