This template runs once a day, requests JSON from the URL you set, parses it in JavaScript, and inserts a PostgreSQL row.
Use it to snapshot an API, a feed, or a system that exposes data at a stable endpoint. Put any API token on the HTTP request node. Put database credentials on the PostgreSQL connection.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
A schedule starts the scenario once per day at the time you choose.
An HTTP request loads data from the URL you set. Put any API token on that HTTP node.
JavaScript parses the payload into the columns your table expects.
PostgreSQL writes those fields into the table you choose.
Add a schedule that runs once every 24 hours. Pick a time in your timezone.
Add an HTTP request. Set the method and URL for the source. Store any API token on that node.
Add a PostgreSQL connection and paste the host, database, user, and password there. Choose the table that should receive rows.
In JavaScript, return stable field names that match your table columns, then insert the row. Run once by hand and confirm the new record.
FAQ
More templates
This template starts when Gravity Forms receives a new entry and POSTs that payload to the webhook URL you choose. Use it to hand form data to another system without copying fields by hand. Connect Gravity Forms. Put Gravity Forms access on the Gravity Forms connection. Put the destination URL, and any destination secret, on the HTTP request node.
This template receives data on a Latenode webhook, maps the payload in JavaScript, and creates a record in your Knack app. JavaScript calls the Knack API with the object id and field values. Put the Knack API key in that JavaScript node. Paste the webhook URL into the system that sends events, then test with one payload.
This template turns incoming webhook events into Opsgenie alerts. Point your monitoring or app webhook at Latenode. JavaScript reads event type, resource, and message, then posts an alert to the Opsgenie Alerts API. Put the Opsgenie API key in that JavaScript node.
