# API POST to create new row on UD table

**URL:** <https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508>\
**Category:** Kinetic ERP\
**Tags:** api, kinetic, ud-table\
**Created:** [March 6, 2024, 9:34pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508 "2024-03-06T21:34:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrew1](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/9de053/32.png) [@andrew1](https://www.epiusers.help/u/andrew1)\
**Post date:** [March 6, 2024, 9:34pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/1 "2024-03-06T21:34:50Z")

</div>

I am attempting to use the rest api and a POST call to create a new row on UD02 ud table. I have been able to do this with other tables, but any combination of fields that I use in swagger UI returns “unable to deserialize entity” code 400 Bad Request.

Can anybody provide me a BARE MINIMUM json with as few fields as necessary to create 1 row of data through the api. I can update the company field with my company id and then I will add in the fields I want to use one at a time once I can get that working. Thanks.

 ![image](https://www.epiusers.help/uploads/default/original/3X/3/1/316004eb3c25a30795bc6caf458a13a47127674c.png)

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [March 7, 2024, 1:34pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/2 "2024-03-07T13:34:35Z")

</div>

This JSON works perfectly on UDXX.Update

```auto
{
  "ds": {
    "UD10": [
      {
        "Company": "C1",
        "Key1": "Data1",
        "Key2": "Data2",
        "Key3": "",
        "Key4": "",
        "Key5": "",
        "Character01": "Mooooo",
        "SysRowID": "00000000-0000-0000-0000-000000000000",
        "RowMod": "A"
      }
    ],
    "UD10Attch": [],
    "ExtensionTables": []
  }
}

```

🙂

---

<div class="post-metadata">

**Author:** ![andrew1](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/9de053/32.png) [@andrew1](https://www.epiusers.help/u/andrew1)\
**Post date:** [March 7, 2024, 2:11pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/3 "2024-03-07T14:11:50Z")

</div>

You’re right that did work perfectly. Must have been my sysrowid or rowmod then. Thanks!

---

<div class="post-metadata">

**Author:** ![aarong](https://www.epiusers.help/user_avatar/www.epiusers.help/aarong/32/101218_2.png) [@aarong](https://www.epiusers.help/u/aarong)\
**Post date:** [March 7, 2024, 2:12pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/4 "2024-03-07T14:12:42Z")

</div>

Maybe… the odata endpoints can be a right anus!!

---

<div class="post-metadata">

**Author:** ![andrew1](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/9de053/32.png) [@andrew1](https://www.epiusers.help/u/andrew1)\
**Post date:** [March 7, 2024, 2:48pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/5 "2024-03-07T14:48:42Z")

</div>

Oh one of my coworkers pointed out that RowMod is expecting A, U, or D for Add Update Delete. On the json template Swagger UI provides it defaults in as “string” so that was probably what was causing my error specifically. Might be useful information for anybody that stumbles on this post later.

---

<div class="post-metadata">

**Author:** ![andrew1](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/9de053/32.png) [@andrew1](https://www.epiusers.help/u/andrew1)\
**Post date:** [March 7, 2024, 4:27pm UTC](https://www.epiusers.help/t/api-post-to-create-new-row-on-ud-table/112508/6 "2024-03-07T16:27:40Z")

</div>

And also if you have a UD field on your table that is a numeric, the Swagger UI loads it in as “Int Field Name: 0” in the JSON template, but the call will return a 400 error unless you make your 0 a string like “0”. Looking back this was likely the actual cause of my 400 error from original post.
