Import CartoDB file with cURL (Mac version)

cdb_import.sh

#!/bin/bash
 
CDB_USER=$1
API_KEY=$2
IMPORT_FILE=$3
 
if [[ -z $CDB_USER ]]
then
  echo "Missing user"
fi
if [[ -z $API_KEY ]]
then
  echo "Missing api key"
fi
if [[ -z $IMPORT_FILE ]]
then
  echo "Missing file"
fi
 
echo "Sending file..."
job_id=`curl -s -F file=@${IMPORT_FILE} "https://${CDB_USER}.cartodb.com/api/v1/imports/?api_key=${API_KEY}" | sed -E 's/\{\"item_queue_id\":([0-9]+).*/\1/'`

echo "Waiting for job ${job_id} to be completed..."
 
while true 
do
  status=`curl -s "https://${CDB_USER}.cartodb.com/api/v1/imports/${job_id}?api_key=${API_KEY}" | sed -E 's/(.*)\"state\":\"([a-z]+)\"(.*)/\2/'`
  echo "STATE: ${status}"
  if [[ $status == 'complete' ]]
  then
    echo "Import successful"
    break
  fi  
  sleep 2
done

gistfile1.txt

./cdb_import.sh <cdb_username> <api_key> <filename>