gistfile1.rb

#https://services.planningcenteronline.com/oauth/authorize?oauth_token=g4FtOqgGZfpr6NRl3Y1D

client = PlanningCenter::Client.new do |c|
  c.consumer_key = 'y4sgTnxkbuZb53ITfuuE'
  c.consumer_secret = ENV["planningCenterTrelloSyncConsumerSecret"]
  c.access_token = ENV["planningCenterTrelloSyncAccessToken"]
  c.access_token_secret = ENV["planningCenterTrelloSyncAccessTokenSecret"]
end

puts "Getting custom fields"

customFields = client.get("/songs/custom_fields.json")

songListStatusField = customFields.select { |field| field["name"] == "Song list status" }.first

statusOptions = songListStatusField["properties"]

consumer = OAuth::Consumer.new(
  'y4sgTnxkbuZb53ITfuuE',
  ENV["planningCenterTrelloSyncConsumerSecret"],
  site: 'https://services.planningcenteronline.com'
)
oauth = OAuth::AccessToken.new(
  consumer,
  ENV["planningCenterTrelloSyncAccessToken"],
  ENV["planningCenterTrelloSyncAccessTokenSecret"]
)

songs.each do |song|
  if song.list == "Song List"
    status = "Approved"
  elsif song.list == "On Hold"
    status = "On-hold"
  elsif song.list == "No"
    status = "No"
  else
    status = "Pending"
  end
  statusOption = statusOptions.select { |option| option["name"] == status }.first
  planningCenterSong = client.get("/songs/#{song.planningCenterId}.json")
  songStatus = planningCenterSong["properties"].select { |field| field["field_id"] == statusOption["custom_field_id"]}.first
  if songStatus["option_id"] != statusOption["id"]
    puts "#{planningCenterSong["title"]} [#{songStatus["option"]}] -> [#{statusOption["name"]}]"
    songStatus["option"] = statusOption["name"]
    songStatus["option_id"] = statusOption["id"]
    json = {
      "song" =>
      {
        "id" => planningCenterSong["id"],
        "properties" => planningCenterSong["properties"]
      }
    }.to_json
    response = oauth.put(
      "/songs/#{song.planningCenterId}.json",
      json
    )
    p response
    exit
  end
end