Troubleshooting data mapping
Common mistakesCopy
Getting the case wrongCopy
Jsonpaths are case-sensitive!
So if the piece of data you are after is firstName and you enter $.steps.asana-2.person.firstname the connector step will fail!
Getting the number of the connector step wrongCopy
Remember that the prefix of your jsonpath must match the name of the connector/service and the number of the step - e.g. $.steps.slack-1 or $.steps.salesforce-3 or $.steps.loop-2
This is explained in working with data and jsonpaths.
Variables with spaces in them can cause an error!Copy
If the variable you are trying to access is called e.g. Primary User Email then you will need to pass it inside [''] as explained here
FAQs / other scenariosCopy
Sometimes the data from a step doesn't seem to be availableCopy
You may find that you need to go to 'Debug' and click 'use output' for certain steps if it appears that the output is not available when using visual jsonpaths or the connector snake:
You will also be notified in the 'Output' panel for any step when a new version of its schema is available:
Clicking on 'preview' will allow you to update the schema:
I have an array of results, how do I access a result which is not the first in the list?Copy
In this scenario, you would use certain identifying criteria to pull the correct item from the list (for example pull the item where lastName equals Robinson)
This can be done using the List Helpers 'filter' operation
I have an array of results, how do I access the last result in the list?Copy
You can use the List Helpers 'last' operation
How do I check if a piece of data matches a certain value?Copy
Use the Text Helpers 'contains' operation.
How do I put several pieces of data into a single box?Copy
You can use Interpolated mode to combine pieces of data, and e.g. compose a long message which contains those pieces of data.
"Data is too large to be displayed" message in logsCopy
Please see our help center article on dealing with this message