# What is the OData endpoint to get client audit json

**URL:** <https://forum.getodk.org/t/what-is-the-odata-endpoint-to-get-client-audit-json/51539>\
**Category:** Support\
**Tags:** odk-central\
**Created:** [December 18, 2024, 9:23am UTC](https://forum.getodk.org/t/what-is-the-odata-endpoint-to-get-client-audit-json/51539 "2024-12-18T09:23:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![atanu](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/atanu/32/18622_2.png) [@atanu](https://forum.getodk.org/u/atanu)\
**Post date:** [December 18, 2024, 9:23am UTC](https://forum.getodk.org/t/what-is-the-odata-endpoint-to-get-client-audit-json/51539/1 "2024-12-18T09:23:29Z")

</div>

Context: OData endpoint provides the data from the submissions and those endpoints are provided here [https://docs.getodk.org/central-api-odata-endpoints](https://docs.getodk.org/central-api-odata-endpoints). You can get the JSON of the submission CSV using this endpoint.

When the audit is enabled, it collects data for

1. 
  - instance ID

2. 
  - event

3. 
  - node

4. 
  - start

5. 
  - end

6. 
  - latitude

7. 
  - longitude

8. 
  - accuracy

9. 
  - old-value

10. 
  - new-value

However, there is API endpoint where i can get the JSON through API.

The fields being generated like this (as example) for download:  
Main data file: Audit-test-v2.csv  
Audit file: Audit-test-v2 - audit. csv (yes, with spaces)

Ask: Is there any existing OData endpoint to get the audit json that is not mentioned in the documentation? Is not can it be provided in the ODK Central's upcoming release?

---

<div class="post-metadata">

**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\
**Post date:** [January 6, 2025, 7:19pm UTC](https://forum.getodk.org/t/what-is-the-odata-endpoint-to-get-client-audit-json/51539/2 "2025-01-06T19:19:43Z")

</div>

There isn't currently an OData endpoint for the combined client audit log. This is something we've considered doing but haven't yet acted on because we hadn't previously received an explicit request for it and because we need to design a reasonable want to give each log line a unique ID which is an OData requirement.

Can you please say a little bit more about what you're hoping to do? I imagine you want to have some analysis that can update as new submissions come in? For that need, I think an endpoint that lets you get the combined CSV -- the file with `- audit.csv` suffix that is downloaded with the zip -- would likely satisfy the need.

---

<div class="post-metadata">

**Author:** ![atanu](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/atanu/32/18622_2.png) [@atanu](https://forum.getodk.org/u/atanu)\
**Post date:** [January 7, 2025, 1:27am UTC](https://forum.getodk.org/t/what-is-the-odata-endpoint-to-get-client-audit-json/51539/3 "2025-01-07T01:27:31Z")

</div>

Hi @LN  
Thank you for your reply. Some ODK users aim to check the individual data submission's audit log—primarily triangulate the data point with the location coordinate on a map in a dashboard. I am able to create a basic data submission dashboard (screenshot below) without the audit part.

 ![CleanShot 2025-01-07 at 06.55.26@2x](https://getodk.b-cdn.net/uploads/default/original/3X/3/c/3c7093483c0c2c75315e10c2d0bafa2f96b5be98.png)

Thank you  
Atanu
