I'm not certain I'm going to word this in a way that makes sense but I'll give it my best shot.
I am using Weweb as a front-end with Xano as my back-end. I have a table/collection that for the sake of simplicity has 6 different fields.
ID
title
start date
end date
user
notes
In this particular case the initial creation of a new record may only include a start date and title and of course the ID which will auto generate. Over a period of time the other fields will be populated but most likely at separate times.
I'm trying to determine what the best method is for update. My concern would be having one API call that updates the fields if all are not populated. So in other words if the title is set I wouldn't want to over write it with a null value. Is it better to have an end point for each field and just call them as needed? Is the patch end point the ideal solution? I want this to be efficient as possible and I feel that the multiple single API calls would be more of a burden than necessary if there's a more efficient way I'd love to hear it. Also, if I'm thinking about this all wrong please let me know.
Thanks in advance.