Migrating Symphony CMS REST API data to Sanity.io

a_README.md

Migrating Symphony CMS REST API data to Sanity.io

Note: Using jq to transform JSON data.

1. Original Data from the REST API extension in Symphony CMS --> example-01.json

2. Clean-up original json data with jq from the command-line. --> example-02.json (cleaner JSON data)

cat example-01.json | jq '[.response.entry[] | {_type: "sermons", title: .title.value, date: .date.date.start._iso, scripture: .scripture.value, speaker: .["speaker-name"].value,audio: .["simplecast-url"].value}]' > example-02.json

3. Clean-up original json data and convert to NDJSON --> example-02.ndjson

cat example-01.json | jq -c '.response.entry[] | {_type: "sermons", title: .title.value, date: .date.date.start._iso, scripture: .scripture.value, speaker: .["speaker-name"].value,audio: .["simplecast-url"].value}' > example-02.ndjson

example-01.json

{
    "response": {
      "section": {
        "_id": "4",
        "_handle": "audio-morning-sermons",
        "value": "Audio: Morning Sermons"
      },
      "entry": [
        {
          "_id": "22954",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-apostolic-benediction",
            "value": "The Apostolic Benediction"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-06-02T11:00:00-05:00",
                "_timestamp": "1559491200",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-06-02"
              }
            }
          },
          "scripture": {
            "_handle": "2-corinthians-13-14",
            "value": "2 Corinthians 13:14"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22955",
              "_creation-date": "2019-05-24T16:18:10-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-b9bcab82-cc5c-4fd6-b60f-15e568ec2393-20190602-0930am-worship-audio-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/b9bcab82-cc5c-4fd6-b60f-15e568ec2393/20190602_0930am_worship_audio_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22610",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "let-us-fall-into-the-hand-of-the-lord-for-his-mercy-is-great",
            "value": "Let Us Fall into the Hand of the Lord, for His Mercy is Great"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-05-26T11:00:00-05:00",
                "_timestamp": "1558886400",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-05-26"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-24",
            "value": "2 Samuel 24"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-47613cb5-df3b-4664-a1ff-395cbcc65d87-20190526-davis9am-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/47613cb5-df3b-4664-a1ff-395cbcc65d87/20190526_davis9am_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22609",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "our-enduring-song",
            "value": "Our Enduring Song"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-05-19T11:00:00-05:00",
                "_timestamp": "1558281600",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-05-19"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-22-1-20-47-51",
            "value": "2 Samuel 22:1-20; 47-51"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-fce0fee1-7dff-4d89-bb87-41d5df4cb732-20190519-11amfray-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/fce0fee1-7dff-4d89-bb87-41d5df4cb732/20190519_11amFray_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "matt-fray",
            "value": "Matt Fray"
          }
        },
        {
          "_id": "22608",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-heart-of-rebellion",
            "value": "The Heart of Rebellion"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-05-12T11:00:00-05:00",
                "_timestamp": "1557676800",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-05-12"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-15-1-13-18-6-8-31-33",
            "value": "2 Samuel 15:1-13; 18:6-8, 31-33"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-53c7b12c-ba4f-48af-bc33-1ebc8af125d3-20190512-goebel9am-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/53c7b12c-ba4f-48af-bc33-1ebc8af125d3/20190512_Goebel9am_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22603",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "in-his-sight",
            "value": "In His Sight"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-05-05T11:00:00-05:00",
                "_timestamp": "1557072000",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-05-05"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-12-1-14",
            "value": "2 Samuel 12:1-14"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-f72ddd50-3346-49b5-b4f0-1d7c3bd2c81a-20190505-11amdavis-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/f72ddd50-3346-49b5-b4f0-1d7c3bd2c81a/20190505_11amDavis_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22602",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "when-kings-dont-go-to-war",
            "value": "When Kings Don't Go To War"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-04-28T11:00:00-05:00",
                "_timestamp": "1556467200",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-04-28"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-11-1-3-1-peter-5-8-9-matthew-4-10-11-romans-13-14",
            "value": "2 Samuel 11:1-3; 1 Peter 5:8-9; Matthew 4:10-11; Romans 13:14"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-cb92c555-0709-4fe5-bb74-0664a9f20f96-20190428-davis9am-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/cb92c555-0709-4fe5-bb74-0664a9f20f96/20190428_davis9am_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22599",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "resurrecting-pleasure",
            "value": "Resurrecting Pleasure"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-04-21T11:00:00-05:00",
                "_timestamp": "1555862400",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-04-21"
              }
            }
          },
          "scripture": {
            "_handle": "psalm-16",
            "value": "Psalm 16"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22590",
              "_creation-date": "2019-03-19T10:26:13-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-0a6e75f2-8a64-4523-9cd0-f6358d054028-20190421-8amdavis-01-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/0a6e75f2-8a64-4523-9cd0-f6358d054028/20190421_8amDavis_01_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22598",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-swarming-bees",
            "value": "The Swarming Bees"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-04-14T11:00:00-05:00",
                "_timestamp": "1555257600",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-04-14"
              }
            }
          },
          "scripture": {
            "_handle": "psalm-118-john-12-12-15",
            "value": "Psalm 118; John 12:12-15"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22590",
              "_creation-date": "2019-03-19T10:26:13-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-94a75266-b0ae-4ab1-936f-891b20a133cf-20190414-davis-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/94a75266-b0ae-4ab1-936f-891b20a133cf/20190414_davis_tc.mp3"
          },
          "speaker-name": {
            "_handle": "mark-davis",
            "value": "Mark Davis"
          }
        },
        {
          "_id": "22595",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "a-promise-to-david-that-only-jesus-could-fulfill",
            "value": "A Promise to David, that only Jesus could Fulfill"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-04-07T11:00:00-05:00",
                "_timestamp": "1554652800",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-04-07"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-7-1-17-8-114b-15",
            "value": "2 Samuel 7:1-17; 8:1,14b-15"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-18471cea-279a-43da-8cdb-649795db2cf5-20190407-duncan-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/18471cea-279a-43da-8cdb-649795db2cf5/20190407_duncan_tc.mp3"
          },
          "speaker-name": {
            "_handle": "j-ligon-duncan-iii",
            "value": "J. Ligon Duncan III"
          }
        },
        {
          "_id": "22593",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-heart-of-a-worshiper",
            "value": "The Heart of a Worshiper"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-03-31T11:00:00-05:00",
                "_timestamp": "1554048000",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-03-31"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-6-1-23",
            "value": "2 Samuel 6:1-23"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-cdnsimplecastcom-audio-605de9-605de9e7-cfff-47ab-af2c-d6740384ffd5-e0e730b7-0f62-4017-85c2-931ea2d7585f-20190331-goebel1-tcmp3",
            "value": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/e0e730b7-0f62-4017-85c2-931ea2d7585f/20190331_goebel1_tc.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22591",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-greatest-miracle",
            "value": "The Greatest Miracle"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-03-24T11:00:00-05:00",
                "_timestamp": "1553443200",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-03-24"
              }
            }
          },
          "scripture": {
            "_handle": "1-kings-19-1-18",
            "value": "1 Kings 19:1-18"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22508",
              "_creation-date": "2019-03-05T07:58:13-06:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-c5bdd5b6mp3",
            "value": "https://audio.simplecast.com/c5bdd5b6.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22549",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "how-long-will-you-waver",
            "value": "How Long Will You Waver"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-03-17T11:00:00-05:00",
                "_timestamp": "1552838400",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-03-17"
              }
            }
          },
          "scripture": {
            "_handle": "1-kings-18-17-25-29-40-james-1-5-8",
            "value": "1 Kings 18:17-25, 29-40; James 1:5-8"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22508",
              "_creation-date": "2019-03-05T07:58:13-06:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-6e94f03emp3",
            "value": "https://audio.simplecast.com/6e94f03e.mp3"
          },
          "speaker-name": {
            "_handle": "pete-deison",
            "value": "Pete Deison"
          }
        },
        {
          "_id": "22509",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "god-s-grace-for-the-low",
            "value": "God’s Grace for the Low"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-03-10T11:00:00-05:00",
                "_timestamp": "1552233600",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0500",
                "value": "2019-03-10"
              }
            }
          },
          "scripture": {
            "_handle": "1-kings-17-1-24-luke-4-25-26",
            "value": "1 Kings 17:1-24; Luke 4:25-26"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22508",
              "_creation-date": "2019-03-05T07:58:13-06:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-1cb7ef8fmp3",
            "value": "https://audio.simplecast.com/1cb7ef8f.mp3"
          },
          "speaker-name": {
            "_handle": "matt-fray",
            "value": "Matt Fray"
          }
        },
        {
          "_id": "22470",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-messy-work-of-redemption",
            "value": "The Messy Work of Redemption"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-03-03T09:30:00-06:00",
                "_timestamp": "1551627000",
                "_time": "09:30",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-03-03"
              }
            }
          },
          "scripture": {
            "_handle": "2-samuel-5-1-5-10-12",
            "value": "2 Samuel 5:1-5, 10-12"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-4475e3f0mp3",
            "value": "https://audio.simplecast.com/4475e3f0.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22419",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-end-of-saul",
            "value": "The End of Saul"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-02-24T11:00:00-06:00",
                "_timestamp": "1551027600",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-02-24"
              }
            }
          },
          "scripture": {
            "_handle": "1-samuel-28-3-20-1-samuel-31-1-6",
            "value": "1 Samuel 28:3-20; 1 Samuel 31:1-6"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-29ee6baemp3",
            "value": "https://audio.simplecast.com/29ee6bae.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22367",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "our-generous-god-creator-and-redeemer",
            "value": "Our Generous God: Creator and Redeemer"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-02-17T11:00:00-06:00",
                "_timestamp": "1550422800",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-02-17"
              }
            }
          },
          "scripture": {
            "_handle": "genesis-1-1-10",
            "value": "Genesis 1:1-10"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "22366",
              "_creation-date": "2019-02-11T08:08:01-06:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-4e920a9amp3",
            "value": "https://audio.simplecast.com/4e920a9a.mp3"
          },
          "speaker-name": {
            "_handle": "tim-tinsley",
            "value": "Tim Tinsley"
          }
        },
        {
          "_id": "22340",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "enemies",
            "value": "Enemies"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-02-10T11:00:00-06:00",
                "_timestamp": "1549818000",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-02-10"
              }
            }
          },
          "scripture": {
            "_handle": "1-samuel-24-1-20",
            "value": "1 Samuel 24:1-20"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-32ad04e8mp3",
            "value": "https://audio.simplecast.com/32ad04e8.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        },
        {
          "_id": "22253",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "jealousy-or-love",
            "value": "Jealousy or Love"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-02-03T11:00:00-06:00",
                "_timestamp": "1549213200",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-02-03"
              }
            }
          },
          "scripture": {
            "_handle": "1-samuel-18-1-12-19-1-7-20-30-33",
            "value": "1 Samuel 18:1-12; 19:1-7; 20:30-33"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-6ad78faemp3",
            "value": "https://audio.simplecast.com/6ad78fae.mp3"
          },
          "speaker-name": {
            "_handle": "brent-baker",
            "value": "Brent Baker"
          }
        },
        {
          "_id": "22034",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "delivered-from-fear-to-freedom",
            "value": "Delivered from Fear to Freedom "
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-01-27T11:00:00-06:00",
                "_timestamp": "1548608400",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-01-27"
              }
            }
          },
          "scripture": {
            "_handle": "1-samuel-17",
            "value": "1 Samuel 17"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-a495808dmp3",
            "value": "https://audio.simplecast.com/a495808d.mp3"
          },
          "speaker-name": {
            "_handle": "julian-russell",
            "value": "Julian Russell"
          }
        },
        {
          "_id": "22033",
          "_series-sermons": "1",
          "_people-speakers": "1",
          "_documents-order-of-worship": "1",
          "title": {
            "_handle": "the-lord-looks-on-the-heart",
            "value": "The Lord Looks on the Heart"
          },
          "date": {
            "date": {
              "_timeline": "1",
              "_type": "exact",
              "start": {
                "_iso": "2019-01-20T11:00:00-06:00",
                "_timestamp": "1548003600",
                "_time": "11:00",
                "_weekday": "7",
                "_offset": "-0600",
                "value": "2019-01-20"
              }
            }
          },
          "scripture": {
            "_handle": "1-samuel-16-1-13",
            "value": "1 Samuel 16:1-13"
          },
          "series": {
            "_field-id": "104",
            "_subsection-id": "12",
            "_items": "1",
            "item": {
              "_id": "21215",
              "_creation-date": "2018-08-13T10:40:26-05:00",
              "value": ""
            }
          },
          "simplecast-url": {
            "_handle": "https-audiosimplecastcom-1a816cb4mp3",
            "value": "https://audio.simplecast.com/1a816cb4.mp3"
          },
          "speaker-name": {
            "_handle": "paul-goebel",
            "value": "Paul Goebel"
          }
        }
      ]
    }
  }

example-02.json

[
  {
    "_type": "sermons",
    "title": "The Apostolic Benediction",
    "date": "2019-06-02T11:00:00-05:00",
    "scripture": "2 Corinthians 13:14",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/b9bcab82-cc5c-4fd6-b60f-15e568ec2393/20190602_0930am_worship_audio_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "Let Us Fall into the Hand of the Lord, for His Mercy is Great",
    "date": "2019-05-26T11:00:00-05:00",
    "scripture": "2 Samuel 24",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/47613cb5-df3b-4664-a1ff-395cbcc65d87/20190526_davis9am_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "Our Enduring Song",
    "date": "2019-05-19T11:00:00-05:00",
    "scripture": "2 Samuel 22:1-20; 47-51",
    "speaker": "Matt Fray",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/fce0fee1-7dff-4d89-bb87-41d5df4cb732/20190519_11amFray_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Heart of Rebellion",
    "date": "2019-05-12T11:00:00-05:00",
    "scripture": "2 Samuel 15:1-13; 18:6-8, 31-33",
    "speaker": "Paul Goebel",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/53c7b12c-ba4f-48af-bc33-1ebc8af125d3/20190512_Goebel9am_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "In His Sight",
    "date": "2019-05-05T11:00:00-05:00",
    "scripture": "2 Samuel 12:1-14",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/f72ddd50-3346-49b5-b4f0-1d7c3bd2c81a/20190505_11amDavis_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "When Kings Don't Go To War",
    "date": "2019-04-28T11:00:00-05:00",
    "scripture": "2 Samuel 11:1-3; 1 Peter 5:8-9; Matthew 4:10-11; Romans 13:14",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/cb92c555-0709-4fe5-bb74-0664a9f20f96/20190428_davis9am_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "Resurrecting Pleasure",
    "date": "2019-04-21T11:00:00-05:00",
    "scripture": "Psalm 16",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/0a6e75f2-8a64-4523-9cd0-f6358d054028/20190421_8amDavis_01_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Swarming Bees",
    "date": "2019-04-14T11:00:00-05:00",
    "scripture": "Psalm 118; John 12:12-15",
    "speaker": "Mark Davis",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/94a75266-b0ae-4ab1-936f-891b20a133cf/20190414_davis_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "A Promise to David, that only Jesus could Fulfill",
    "date": "2019-04-07T11:00:00-05:00",
    "scripture": "2 Samuel 7:1-17; 8:1,14b-15",
    "speaker": "J. Ligon Duncan III",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/18471cea-279a-43da-8cdb-649795db2cf5/20190407_duncan_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Heart of a Worshiper",
    "date": "2019-03-31T11:00:00-05:00",
    "scripture": "2 Samuel 6:1-23",
    "speaker": "Paul Goebel",
    "audio": "https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/e0e730b7-0f62-4017-85c2-931ea2d7585f/20190331_goebel1_tc.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Greatest Miracle",
    "date": "2019-03-24T11:00:00-05:00",
    "scripture": "1 Kings 19:1-18",
    "speaker": "Paul Goebel",
    "audio": "https://audio.simplecast.com/c5bdd5b6.mp3"
  },
  {
    "_type": "sermons",
    "title": "How Long Will You Waver",
    "date": "2019-03-17T11:00:00-05:00",
    "scripture": "1 Kings 18:17-25, 29-40; James 1:5-8",
    "speaker": "Pete Deison",
    "audio": "https://audio.simplecast.com/6e94f03e.mp3"
  },
  {
    "_type": "sermons",
    "title": "God’s Grace for the Low",
    "date": "2019-03-10T11:00:00-05:00",
    "scripture": "1 Kings 17:1-24; Luke 4:25-26",
    "speaker": "Matt Fray",
    "audio": "https://audio.simplecast.com/1cb7ef8f.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Messy Work of Redemption",
    "date": "2019-03-03T09:30:00-06:00",
    "scripture": "2 Samuel 5:1-5, 10-12",
    "speaker": "Paul Goebel",
    "audio": "https://audio.simplecast.com/4475e3f0.mp3"
  },
  {
    "_type": "sermons",
    "title": "The End of Saul",
    "date": "2019-02-24T11:00:00-06:00",
    "scripture": "1 Samuel 28:3-20; 1 Samuel 31:1-6",
    "speaker": "Paul Goebel",
    "audio": "https://audio.simplecast.com/29ee6bae.mp3"
  },
  {
    "_type": "sermons",
    "title": "Our Generous God: Creator and Redeemer",
    "date": "2019-02-17T11:00:00-06:00",
    "scripture": "Genesis 1:1-10",
    "speaker": "Tim Tinsley",
    "audio": "https://audio.simplecast.com/4e920a9a.mp3"
  },
  {
    "_type": "sermons",
    "title": "Enemies",
    "date": "2019-02-10T11:00:00-06:00",
    "scripture": "1 Samuel 24:1-20",
    "speaker": "Paul Goebel",
    "audio": "https://audio.simplecast.com/32ad04e8.mp3"
  },
  {
    "_type": "sermons",
    "title": "Jealousy or Love",
    "date": "2019-02-03T11:00:00-06:00",
    "scripture": "1 Samuel 18:1-12; 19:1-7; 20:30-33",
    "speaker": "Brent Baker",
    "audio": "https://audio.simplecast.com/6ad78fae.mp3"
  },
  {
    "_type": "sermons",
    "title": "Delivered from Fear to Freedom ",
    "date": "2019-01-27T11:00:00-06:00",
    "scripture": "1 Samuel 17",
    "speaker": "Julian Russell",
    "audio": "https://audio.simplecast.com/a495808d.mp3"
  },
  {
    "_type": "sermons",
    "title": "The Lord Looks on the Heart",
    "date": "2019-01-20T11:00:00-06:00",
    "scripture": "1 Samuel 16:1-13",
    "speaker": "Paul Goebel",
    "audio": "https://audio.simplecast.com/1a816cb4.mp3"
  }
]

example-02.ndjson

{"_type":"sermons","title":"The Apostolic Benediction","date":"2019-06-02T11:00:00-05:00","scripture":"2 Corinthians 13:14","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/b9bcab82-cc5c-4fd6-b60f-15e568ec2393/20190602_0930am_worship_audio_tc.mp3"}
{"_type":"sermons","title":"Let Us Fall into the Hand of the Lord, for His Mercy is Great","date":"2019-05-26T11:00:00-05:00","scripture":"2 Samuel 24","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/47613cb5-df3b-4664-a1ff-395cbcc65d87/20190526_davis9am_01_tc.mp3"}
{"_type":"sermons","title":"Our Enduring Song","date":"2019-05-19T11:00:00-05:00","scripture":"2 Samuel 22:1-20; 47-51","speaker":"Matt Fray","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/fce0fee1-7dff-4d89-bb87-41d5df4cb732/20190519_11amFray_01_tc.mp3"}
{"_type":"sermons","title":"The Heart of Rebellion","date":"2019-05-12T11:00:00-05:00","scripture":"2 Samuel 15:1-13; 18:6-8, 31-33","speaker":"Paul Goebel","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/53c7b12c-ba4f-48af-bc33-1ebc8af125d3/20190512_Goebel9am_01_tc.mp3"}
{"_type":"sermons","title":"In His Sight","date":"2019-05-05T11:00:00-05:00","scripture":"2 Samuel 12:1-14","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/f72ddd50-3346-49b5-b4f0-1d7c3bd2c81a/20190505_11amDavis_01_tc.mp3"}
{"_type":"sermons","title":"When Kings Don't Go To War","date":"2019-04-28T11:00:00-05:00","scripture":"2 Samuel 11:1-3; 1 Peter 5:8-9; Matthew 4:10-11; Romans 13:14","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/cb92c555-0709-4fe5-bb74-0664a9f20f96/20190428_davis9am_01_tc.mp3"}
{"_type":"sermons","title":"Resurrecting Pleasure","date":"2019-04-21T11:00:00-05:00","scripture":"Psalm 16","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/0a6e75f2-8a64-4523-9cd0-f6358d054028/20190421_8amDavis_01_tc.mp3"}
{"_type":"sermons","title":"The Swarming Bees","date":"2019-04-14T11:00:00-05:00","scripture":"Psalm 118; John 12:12-15","speaker":"Mark Davis","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/94a75266-b0ae-4ab1-936f-891b20a133cf/20190414_davis_tc.mp3"}
{"_type":"sermons","title":"A Promise to David, that only Jesus could Fulfill","date":"2019-04-07T11:00:00-05:00","scripture":"2 Samuel 7:1-17; 8:1,14b-15","speaker":"J. Ligon Duncan III","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/18471cea-279a-43da-8cdb-649795db2cf5/20190407_duncan_tc.mp3"}
{"_type":"sermons","title":"The Heart of a Worshiper","date":"2019-03-31T11:00:00-05:00","scripture":"2 Samuel 6:1-23","speaker":"Paul Goebel","audio":"https://cdn.simplecast.com/audio/605de9/605de9e7-cfff-47ab-af2c-d6740384ffd5/e0e730b7-0f62-4017-85c2-931ea2d7585f/20190331_goebel1_tc.mp3"}
{"_type":"sermons","title":"The Greatest Miracle","date":"2019-03-24T11:00:00-05:00","scripture":"1 Kings 19:1-18","speaker":"Paul Goebel","audio":"https://audio.simplecast.com/c5bdd5b6.mp3"}
{"_type":"sermons","title":"How Long Will You Waver","date":"2019-03-17T11:00:00-05:00","scripture":"1 Kings 18:17-25, 29-40; James 1:5-8","speaker":"Pete Deison","audio":"https://audio.simplecast.com/6e94f03e.mp3"}
{"_type":"sermons","title":"God’s Grace for the Low","date":"2019-03-10T11:00:00-05:00","scripture":"1 Kings 17:1-24; Luke 4:25-26","speaker":"Matt Fray","audio":"https://audio.simplecast.com/1cb7ef8f.mp3"}
{"_type":"sermons","title":"The Messy Work of Redemption","date":"2019-03-03T09:30:00-06:00","scripture":"2 Samuel 5:1-5, 10-12","speaker":"Paul Goebel","audio":"https://audio.simplecast.com/4475e3f0.mp3"}
{"_type":"sermons","title":"The End of Saul","date":"2019-02-24T11:00:00-06:00","scripture":"1 Samuel 28:3-20; 1 Samuel 31:1-6","speaker":"Paul Goebel","audio":"https://audio.simplecast.com/29ee6bae.mp3"}
{"_type":"sermons","title":"Our Generous God: Creator and Redeemer","date":"2019-02-17T11:00:00-06:00","scripture":"Genesis 1:1-10","speaker":"Tim Tinsley","audio":"https://audio.simplecast.com/4e920a9a.mp3"}
{"_type":"sermons","title":"Enemies","date":"2019-02-10T11:00:00-06:00","scripture":"1 Samuel 24:1-20","speaker":"Paul Goebel","audio":"https://audio.simplecast.com/32ad04e8.mp3"}
{"_type":"sermons","title":"Jealousy or Love","date":"2019-02-03T11:00:00-06:00","scripture":"1 Samuel 18:1-12; 19:1-7; 20:30-33","speaker":"Brent Baker","audio":"https://audio.simplecast.com/6ad78fae.mp3"}
{"_type":"sermons","title":"Delivered from Fear to Freedom ","date":"2019-01-27T11:00:00-06:00","scripture":"1 Samuel 17","speaker":"Julian Russell","audio":"https://audio.simplecast.com/a495808d.mp3"}
{"_type":"sermons","title":"The Lord Looks on the Heart","date":"2019-01-20T11:00:00-06:00","scripture":"1 Samuel 16:1-13","speaker":"Paul Goebel","audio":"https://audio.simplecast.com/1a816cb4.mp3"}