-
Suggestion
-
Resolution: Unresolved
-
None
-
4
-
21
-
Summary
Currently, Data Connections feature is limited to JSON data accessed via REST API or Jira Properties. So connections to databases, files, and online spreadsheets are not available yet.
The online spreadsheet is not supported to be forms data connections. Using a spreadsheet via Google rest API, unfortunately, doesn’t make a difference. Google sheets API returns ValueRange object, not “a list or array of objects” (required by Forms Data Connections).
Suggestion
Support for an external data connection like Google Sheets. It’s will be great if we can support JsonPath in the future. This will allow writing advanced expressions e.g. to extract the first item of each array $.values.[0].