pgAgent post json to PostgreSQL database

Asked Jan 11 '23 at 21:55

Active Jan 13 '23 at 15:02

Viewed 27 times

I am looking to update JSON data in a PostgreSQL database after the service has been updated or after 28 days. and is it possible to use pgAgent?

I need to bring FAA gis JSON into PostgreSQL. https://services6.arcgis.com/ssFJjBXIUyZDrSYZ/arcgis/rest/services/Digital_Obstacle_File/FeatureServer/0. But need to be up to date so the code should run every 28 days or look for a change in the JSON.

I am trying to run a job that pulls in the json to the database.

edited Jan 13 '23 at 15:02

asked Jan 11 '23 at 21:55

Laura612

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Jan 12 '23 at 08:50

0 Answers0