#!/bin/bash
API_KEY="579b464db66ec23bdd000001f7a9468c04984dd5647da954d30e8f6c"
RESOURCE_ID="9ef84268-d588-465a-a308-a864a43d0070"

echo "Fetching Mandi data..."
curl -s "https://api.data.gov.in/resource/$RESOURCE_ID?api-key=$API_KEY&format=json&limit=1000" | \
jq '.records | map(.arrival_date = (.arrival_date | split("/") | [.[2], .[1], .[0]] | join("-")))' | \
~/code/utils/db-push mandi