I have also posted this to the Xano community because it may be more fitting there but this community always tends to be more involved so I thought I’d post here as well.
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 and for this example lets say it 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.