Long Query

long-query.sh

#!/usr/bin/env bash

set -euo pipefail

CHURCH="'012E0000000Q8x8IAC'"
FOUNDATION="'012E0000000Q8xDIAS'"
GOVERNMENT="'0124400000097hVAAQ'"
ORG="'012E0000000Q8xIIAS'"

echo "---------------------------------------------------------------------"
echo "Set the Type picklist value for the corresponding record type id"
echo "---------------------------------------------------------------------"

# !!! Need to make sure picklist values are in place !!!

Q="   select Id, RecordTypeId"
Q+="  from Account"
Q+="  where RecordTypeId in (${CHURCH},${FOUNDATION},${GOVERNMENT},${ORG})"
Q=$(echo -e "${Q}" | sed -e 's/^[[:space:]]*//')
echo "$Q"

sf-query "${Q}" \
  | sed '1s/^.*$/Id,Type/' \
  | sed 's/012E0000000Q8x8IAC/Church/' \
  | sed 's/012E0000000Q8xDIAS/Foundation/' \
  | sed 's/0124400000097hVAAQ/Government/' \
  | sed 's/012E0000000Q8xIIAS/Organization/' \
  | sf-update Account poll