Best Practice to submit a POST request from FORM

Queries and Resources
1

Hi,
I have a POST api that required different data to create a order. I have made a form now what are the best practices to implement this.

on a form submit event how should I trigger the api resource and how should I even define the post end point.

Can I do something like this: on submit of a form -> trigger a query -> there process the form data and make a json -> trigger actual endpoint and pass that json ?

Let me know how you guys do these .
Thanks

2

Hi @mpmohi! Happy to help with this. Here are some docs that might help:

https://docs.retool.com/docs/insert-csvs-into-a-database#3-posting-rows-to-a-sample-api

https://docs.retool.com/docs/create-forms-using-form-component#update-the-query-to-create-and-update-records

I can also help guide you along if you share a screenshot of your current setup!