Pending rename.. [Jun 11]

Discord-Discussions
1

:raising_hand_man: λRick asked

I’m getting this response for the PATCH endpoint. I’m sending the JSON object with the new column values using a PATCH HTTP request, sending Content-Type application/json.

What could be then issue?

{“msg”:“Empty .update() call detected! Update data does not contain any values to update. This will result in a faulty query. Table: nc_tp2z__***. Columns: .”}

Status code 400

2

:raising_hand_man: FrancyMak replied

Clould you send me your request json?

3

:raising_hand_man: λRick replied

{"GitHub Stars": 2279, "updated_at": "2022-05-29 11:01"}

4

:raising_hand_man: FrancyMak replied

I am a recent arrival to the noco team, so I am still figuring out how their APIs work, and I would not want to give false guidance. Therefore, I will leave you to one of our software engineers who will be able to help you more than me.

5

:raising_hand_man: FrancyMak replied

<@&682859083799199814>

6

:raising_hand_man: FrancyMak replied

but, would be helpful, if you can send the path parametes that you’re using (you can rename sensible content)

7

:raising_hand_man: wkw replied

<@198536651348115466> which endpoint are you using?

8

:raising_hand_man: λRick replied

/api/v1/db/data/noco/tools/tools/{rowId}

9

:raising_hand_man: wkw replied

ok. thats dbTableRow.update. can u share your table schema

10

:raising_hand_man: wkw replied

and how you send the request? if u r using curl, then share the full command with sensitive info redacted

11

:raising_hand_man: λRick replied

```{

“A”: “string”,

“B”: “string”,

“C”: “string”,

“D”: “string”,

“E”: “string”,

“F”: “string”,

“G”: “string”,

“H”: “string”,

“I”: “string”,

“J”: “string”,

“K”: “string”,

“L”: “string”,

“M”: “string”,

“N”: “string”,

“O”: “string”,

“P”: “string”,

“Q”: 0,

“GitHub Stars”: 0,

“id”: 0,

“R”: “string”

}```

12

:raising_hand_man: λRick replied

```

resp = requests.patch(update_endpoint, data=json.dumps(delta_obj), headers={“xc-auth”: xc_key, “Content-Type”: “application/json”})

```

13

:raising_hand_man: λRick replied

Any idea?

14

:raising_hand_man: wkw replied

sorry. forget to press enter …

may i confirm the following

- update_endpoint includes the row id

- xc_key is auth token, not api token

15

:raising_hand_man: λRick replied

Both yes

16

:raising_hand_man: λRick replied

Found the cause, was using the HTTP instead of the HTTPS endpoint. Some of the endpoint API calls were working just fine on HTTP, and the error didn’t point at this being the issue at all. What made me discover it was the Swagger UI in which the PATCH call did work.

17

:raising_hand_man: λRick replied

Kept reducing differences until literally the last things left to try was the protocol

18

:man_bald: dstala replied

<@198536651348115466> Thanks for updating the conclusion summary

19

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs