Pending rename.. [Jun 11]

: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

:raising_hand_man: FrancyMak replied

Clould you send me your request json?

:raising_hand_man: λRick replied

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

: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.

:raising_hand_man: FrancyMak replied


: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)

:raising_hand_man: wkw replied

<@198536651348115466> which endpoint are you using?

:raising_hand_man: λRick replied


:raising_hand_man: wkw replied

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

: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

: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”


:raising_hand_man: λRick replied


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


:raising_hand_man: λRick replied

Any idea?

: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

:raising_hand_man: λRick replied

Both yes

: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.

:raising_hand_man: λRick replied

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

:man_bald: dstala replied

<@198536651348115466> Thanks for updating the conclusion summary

Autogenerated from discord

Join NocoDB’s community