Add record from form submission using PHP

[Cleven]

Hi, I need help to add record from landing page form submission to Grist table using PHP. Is there any sample code I can refer to achieve this?

Thank you

[paul-grist]

There’s an example of reading data here:

How do I access a specific record in a Grist Table via API?

Hi Michael, Here is a sample php code that works for me. When you use your API key, you should be able to invoke it as it is. It gets records from one of Grist’s templates (link) and filters them by the order id column. You can read more about the API in the help center API reference - Grist Help Center. Each endpoint has an accordion section with examples how to construct URLs to the Grist API, for example: [image] <?php function gristQuery($pquery) { // This is a Grist template doc…

Adding a record would be the same endpoint, but a POST instead of a GET (documentation). I don’t know enough PHP to suggest the exact changes needed.

By the way, there’s a specification of our api here, which could perhaps be used to generate a PHP client using tools such as swagger-codegen.

gristlabs/grist-help/blob/master/api/grist.yml

[Cleven]

Great, thanks for the info. Appreciate

[dmitry-grist]

This new repo offers another way to record form submissions into Grist: GitHub - gristlabs/grist-form-submit: Turn form submissions on webpages into new records in Grist documents. It doesn’t require PHP, and is good if you just need to collect data from a landing page form.