# \[Bug Report\] Decimal columns labeled as string in openapi.json

**URL:** https://community.nocodb.com/t/bug-report-decimal-columns-labeled-as-string-in-openapi-json/1942
**Category:** Uncategorized
**Created:** [June 17, 2025, 11:03pm UTC](https://community.nocodb.com/t/bug-report-decimal-columns-labeled-as-string-in-openapi-json/1942 "2025-06-17T23:03:17Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![johnbalis](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@johnbalis](https://community.nocodb.com/u/johnbalis)
#### Post date: [June 17, 2025, 11:03pm UTC](https://community.nocodb.com/t/bug-report-decimal-columns-labeled-as-string-in-openapi-json/1942/1 "2025-06-17T23:03:17Z")

</div>

We are using cloud nocodb with Decimal columns, and using [openapi-generator-cli](https://github.com/OpenAPITools/openapi-generator-cli) to build autogenerated rust client crates. We use the following command to generate openapi.json for the data API.

```auto
curl -H "xc-token: <token>" https://app.nocodb.com/api/v1/db/meta/projects/<project id>/swagger.json

```

I noticed that decimal columns in nocodb are getting labeled as string in openapi.json served from this endpoint. Unfortunately rust is very strict about types so this makes it so our autogenerated crates panic when trying to read rows from tables that have decimal columns, because they expect to de-serialize a string but find a floating point number instead.

```auto
ExampleResponse":{
...
Example column ":{"type":"string"}, 
...
}

```

---

<div class="post-metadata">

### Author: ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)
#### Post date: [June 19, 2025, 11:21am UTC](https://community.nocodb.com/t/bug-report-decimal-columns-labeled-as-string-in-openapi-json/1942/2 "2025-06-19T11:21:17Z")

</div>

Thank you for reporting the issue. Its tracked [here](https://github.com/nocodb/nocodb/issues/11718).

---

<div class="post-metadata">

### Author: ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)
#### Post date: [June 26, 2025, 9:05pm UTC](https://community.nocodb.com/t/bug-report-decimal-columns-labeled-as-string-in-openapi-json/1942/3 "2025-06-26T21:05:32Z")

</div>

We’ve fixed the issue where decimal columns were showing as string in OpenAPI JSON.

PR: [#11766 (merged)](https://github.com/nocodb/nocodb/pull/11766)

We’ll roll out the fix later today.