while connecting odk toolkit data to tableau for grid questions it is not connecting the data of sub tables related to grid question but data of main toolkit table is visible. how to connect the sub tables data of grid question from tableau??
We don’t list Tableau as a supported downstream tool because it does not fully comply with the OData specification. That said, if you are technically inclined, you may be able to display the data by providing Tableau with the URLs to the OData Data documents.
-
Data from the main (non-repeats) table
https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc/Submissions
-
Data from the repeats, where
table
is the name of the repeat
https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc/{table}
-
Structure/schema of your data
https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc
You can learn more in the OData endpoint documentation at https://docs.getodk.org/central-api-odata-endpoints.