How to implement the PATCH Method the right way?

devben

In Xano, the PATCH method overwrites the entire object by default. This is not how I imagine it. Normally PATCH should be used for partial changes and PUT should overwrite the object.
So now I am looking for a filter for my fields to overwrite the values only if the keys occur in the request.
I have to say that I imagined this would be easier.
This menu is so badly described that it is not at all clear what the filter is applied to.
How can I apply the filter so that a key value of the request is only written to the appropriate database field if it exists and only if it is not empty or not null or ""?

Louis Machado - CSA

Hi @devben,

I believe this video will help with what you are trying to accomplish.

https://www.loom.com/share/c0db20190558420887c5663975e0fee8?sid=003654a6-a463-407d-8835-aa66fd3f8946

Guillaume Maison

From a bit more technical point of view, you can also process like this : https://www.loom.com/share/bff8150fa4a947ab95cc0f07e65e0b7c?sid=a873ff6c-046d-42fc-8252-9cd1dde516d8

it just requires that you know, from your frontend, how to build JSON dynamically…

devben

@Louis Machado - CSA I don't know why but it works.
My Endpoint has the URL Parameter of the ID of the Xano record so I know which one it is why do I need to first GET the records in order to update them? How does this work?

devben

@Guillaume Maison That's exactly how I imagine it👌Thanks a lot! 🙂