# Using $filter with repeat tables to download OData

**URL:** <https://forum.getodk.org/t/using-filter-with-repeat-tables-to-download-odata/36245>\
**Category:** Support\
**Tags:** odk-central\
**Created:** [December 31, 2021, 9:49am UTC](https://forum.getodk.org/t/using-filter-with-repeat-tables-to-download-odata/36245 "2021-12-31T09:49:46Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\
**Post date:** [November 4, 2022, 3:32pm UTC](https://forum.getodk.org/t/using-filter-with-repeat-tables-to-download-odata/36245/7 "2022-11-04T15:32:36Z")

</div>

Hi @Matthew_White , I am still trying to pull only fresh data from central in order to not download every hour all the data collected since march ([Propagate submission date to child tables - #3 by mathieubossaert](https://forum.getodk.org/t/propagate-submission-date-to-child-tables/34349/3)).  
As @Florian_May said, getting all data every day or every hour works fine, but I am looking for a solution that do not consume resources for nothing in our "real time" data collection workflow)

So a few days ago I read your post with most attention than I did and I thought I found the solution.

> [@Matthew\_White](#):
>
> It is currently possible to fetch a subtable for a single Submission:
> 
> ```auto
> /v1/projects/{{projectId}}/forms/{{xmlFormId}}.svc/Submissions('{{instanceId}}')/{{repeatName}}
> 
> ```

I adapted my sql function to get _submissionId_ from central that are relevant to filters I give (with submissionDate, updatedAt et reviewState parameter.  
It's works fine but I fear it only works for a "one level" repeat form ?

My form contains a "observations" repeat nested in the "location" one. So I achieve to automatically get data for the significant _instanceId_ for both submission and location table but not for observations one.

Am I wrong ?

---

_[View the full topic](https://forum.getodk.org/t/using-filter-with-repeat-tables-to-download-odata/36245)._