...
| Table of Contents | ||
|---|---|---|
|
Current Supported Integrations
| Child pages (Children Display) | ||
|---|---|---|
|
Benefits of Using OData Feeds with CommCare
...
After saving, you will be provided with an OData URL. This URL is used to access your OData feed.
Ensure you have the necessary authentication details, as OData feeds require authentication to access.
Tips & Tricks
...
.
...
When querying Repeat Group OData URLs, the limit and offset parameters operate at the form level, meaning limit=1 will return all responses within a repeat group for one form.
Bulk Delete Integration Feeds
The bulk delete OData integration feed gives you the option to bulk delete multiple exports at once.
These are the steps to bulk delete form export
In the Export Dashboard you will find a check box to select all or specific exports
On checking the box, you will notice a "Delete Selected Export" button becomes available on the left side of the page
Click on the "Delete Selected Export" button and you will be promoted to confirm the bulk delete action
Once Delete Export is clicked it will bulk delete the exports selected at once
...
Tips & Tricks
Best Practices
Secure Your Data: Ensure that access to your OData feed is secured and only available to authorized users.
Monitor Data Usage: Keep an eye on how your OData feed is being used to ensure optimal performance.
Stay Updated: Regularly check for updates on CommCare's OData feed functionality to leverage any new features or improvements.
Set-up a web user read-only role limited to read OData feeds
Navigate to Users / Roles & Permissions
Click +Add Role at the bottom of the page
Provide a name to this role: e.g. Read-Only OData
Unselect all permissions except the ones below:
Export Form Data (if necessary)
Export Case Data (if necessary)
PowerBI/Tableau Integration
Allow role to access data from all locations
Save and assign this role to a user
Repeat Groups
If setting up an OData Feed for a form that contains Repeat Groups , you will also need to reference the additional feeds created for that repeat group data if it is of interest. Each repeat group will have its own OData URL.
...