Skip to content

Instantly share code, notes, and snippets.

@saturov

saturov/flat

Created July 3, 2017 20:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save saturov/64355492b0e7c8d7d2f66f43d3c93809 to your computer and use it in GitHub Desktop.
Save saturov/64355492b0e7c8d7d2f66f43d3c93809 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
flat
{
"data": [
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": 952,
"file_mime": null,
"campaign_uid": "AAAA-BBBB-CCCC",
"file_name": null,
"campaign_state": "campaign_state/open",
"job_workorder_id": 952,
"distribution_date_end": "2016-01-07T23:59:59.000Z",
"campaign_name": "Test Campaign",
"campaign_budget": 99999,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "Test Brief",
"allocation_facespace_id": null,
"campaign_id": 391,
"campaign_redirect_url": "https://www.flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T11:44:52.464Z",
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": "2017-07-03T11:44:52.464Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 742,
"file_created_at": null,
"job_state": "jobstate/open",
"distribution_quantity": 99,
"allocation_state": null,
"file_id": null,
"workorder_status": "workorder_status/initial",
"job_user_id": 1804,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 948,
"campaign_image_id": null,
"distribution_date_start": "2016-01-01T00:00:00.000Z"
},
{
"file_source_identifier": "mobile_pop_app",
"file_creator_id": 1804,
"workorder_id": 953,
"file_mime": "image/png",
"campaign_uid": "AAAA-BBBB-CCCC",
"file_name": "legacy-campaign.png",
"campaign_state": "campaign_state/open",
"job_workorder_id": 953,
"distribution_date_end": "2016-01-07T23:59:59.000Z",
"campaign_name": "Test Campaign",
"campaign_budget": 99999,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "Test Brief",
"allocation_facespace_id": null,
"campaign_id": 391,
"campaign_redirect_url": "https://www.flyerbee.com",
"file_type": "pop-mobile-app",
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T11:44:52.464Z",
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": null,
"file_origin_name": "",
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": 123456,
"job_created_at": "2017-07-03T11:44:52.464Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": "pending",
"file_location": {
"lat": 47.3790832,
"lon": 8.5401318
},
"allocation_created_at": null,
"distribution_id": 742,
"file_created_at": "2017-07-03T11:44:52.464Z",
"job_state": "jobstate/open",
"distribution_quantity": 99,
"allocation_state": null,
"file_id": 2326,
"workorder_status": "workorder_status/initial",
"job_user_id": 1805,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 949,
"campaign_image_id": null,
"distribution_date_start": "2016-01-01T00:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "FAF1-4C68-B6CB",
"file_name": null,
"campaign_state": "campaign_state/open",
"job_workorder_id": null,
"distribution_date_end": "2017-07-10T15:41:25.423Z",
"campaign_name": "pincities",
"campaign_budget": 0,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "",
"allocation_facespace_id": null,
"campaign_id": 393,
"campaign_redirect_url": "",
"file_type": null,
"campaign_brief": "testing pincities",
"campaign_created_at": "2017-07-03T13:18:25.327Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T13:48:43.293Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": 1574,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 748,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 0,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-07-03T15:41:25.423Z"
},
{
"file_source_identifier": "mobile_pop_app",
"file_creator_id": 1805,
"workorder_id": 999,
"file_mime": "image/jpeg",
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": "11b5d76a-0d67-419e-bd18-1d3429e4c08a.jpg",
"campaign_state": "campaign_state/deployment",
"job_workorder_id": 999,
"distribution_date_end": "2017-01-08T08:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": 1521,
"distribution_brief": "Test Brief",
"allocation_facespace_id": 1068,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": "pop-mobile-app",
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T15:06:46.751Z",
"allocation_entity_id": 1562,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": "2017-01-08T08:59:59.000Z",
"file_origin_name": "377",
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": 0,
"job_created_at": "2017-07-03T15:06:46.751Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": "pending",
"file_location": {
"lat": 0,
"lon": 0
},
"allocation_created_at": "2017-07-03T15:06:46.751Z",
"distribution_id": 743,
"file_created_at": "2017-07-03T19:42:41.905Z",
"job_state": "jobstate/done",
"distribution_quantity": 99,
"allocation_state": "allocation_state/deployed",
"file_id": 2347,
"workorder_status": "workorder_status/initial",
"job_user_id": null,
"workorder_allocations_id": 1521,
"allocation_date_start": "2017-01-01T09:00:00.000Z",
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 995,
"campaign_image_id": null,
"distribution_date_start": "2017-01-01T09:00:00.000Z"
},
{
"file_source_identifier": "mobile_pop_app",
"file_creator_id": 1805,
"workorder_id": 1000,
"file_mime": "image/jpeg",
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": "4e230839-b652-4654-876f-287891822aef.jpg",
"campaign_state": "campaign_state/deployment",
"job_workorder_id": 1000,
"distribution_date_end": "2017-01-08T08:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": 1522,
"distribution_brief": "Test Brief",
"allocation_facespace_id": 1069,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": "pop-mobile-app",
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T15:06:46.751Z",
"allocation_entity_id": 1562,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": "2017-01-08T08:59:59.000Z",
"file_origin_name": "1499096077756",
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": 0,
"job_created_at": "2017-07-03T15:06:46.751Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": "present",
"file_location": {
"lat": 47.502743,
"lon": 19.0702898
},
"allocation_created_at": "2017-07-03T15:06:46.751Z",
"distribution_id": 743,
"file_created_at": "2017-07-03T15:35:35.256Z",
"job_state": "jobstate/done",
"distribution_quantity": 99,
"allocation_state": "allocation_state/deployed",
"file_id": 2346,
"workorder_status": "workorder_status/initial",
"job_user_id": null,
"workorder_allocations_id": 1522,
"allocation_date_start": "2017-01-01T09:00:00.000Z",
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 996,
"campaign_image_id": null,
"distribution_date_start": "2017-01-01T09:00:00.000Z"
},
{
"file_source_identifier": "mobile_pop_app",
"file_creator_id": 1805,
"workorder_id": 1001,
"file_mime": "image/jpeg",
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": "3b459fef-9f72-4ff0-bf8d-9c61d623998c.jpg",
"campaign_state": "campaign_state/deployment",
"job_workorder_id": 1001,
"distribution_date_end": "2017-01-08T08:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": 1523,
"distribution_brief": "Test Brief",
"allocation_facespace_id": 1068,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": "pop-mobile-app",
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T15:06:46.751Z",
"allocation_entity_id": 1562,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": "2017-01-08T08:59:59.000Z",
"file_origin_name": "377",
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": 0,
"job_created_at": "2017-07-03T15:06:46.751Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": "pending",
"file_location": {
"lat": 0,
"lon": 0
},
"allocation_created_at": "2017-07-03T15:06:46.751Z",
"distribution_id": 743,
"file_created_at": "2017-07-03T19:59:38.706Z",
"job_state": "jobstate/done",
"distribution_quantity": 99,
"allocation_state": "allocation_state/deployed",
"file_id": 2349,
"workorder_status": "workorder_status/initial",
"job_user_id": null,
"workorder_allocations_id": 1523,
"allocation_date_start": "2017-01-01T09:00:00.000Z",
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 997,
"campaign_image_id": null,
"distribution_date_start": "2017-01-01T09:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": 1002,
"file_mime": null,
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": null,
"campaign_state": "campaign_state/deployment",
"job_workorder_id": 1002,
"distribution_date_end": "2017-01-08T08:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": 1524,
"distribution_brief": "Test Brief",
"allocation_facespace_id": 1070,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": "2017-07-03T15:06:46.751Z",
"allocation_entity_id": 1562,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": "2017-01-08T08:59:59.000Z",
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": "2017-07-03T15:06:46.751Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": "2017-07-03T15:06:46.751Z",
"distribution_id": 743,
"file_created_at": null,
"job_state": "jobstate/open",
"distribution_quantity": 99,
"allocation_state": "allocation_state/reserved",
"file_id": null,
"workorder_status": "workorder_status/initial",
"job_user_id": null,
"workorder_allocations_id": 1524,
"allocation_date_start": "2017-01-01T09:00:00.000Z",
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 998,
"campaign_image_id": null,
"distribution_date_start": "2017-01-01T09:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": null,
"campaign_state": "campaign_state/deployment",
"job_workorder_id": null,
"distribution_date_end": "2017-01-28T11:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "Test Brief",
"allocation_facespace_id": null,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 744,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 40,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-01-08T12:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": null,
"campaign_state": "campaign_state/deployment",
"job_workorder_id": null,
"distribution_date_end": "2017-01-28T11:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "Test Brief",
"allocation_facespace_id": null,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 745,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 210,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-01-08T12:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": null,
"campaign_state": "campaign_state/deployment",
"job_workorder_id": null,
"distribution_date_end": "2017-01-28T11:59:59.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "Please distribute 200 posters",
"allocation_facespace_id": null,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T11:44:52.464Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": 1566,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 746,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 0,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-01-08T12:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "BBBB-CCCC-DDDD",
"file_name": null,
"campaign_state": "campaign_state/deployment",
"job_workorder_id": null,
"distribution_date_end": "2017-07-24T14:00:00.000Z",
"campaign_name": "Another Campaign",
"campaign_budget": 20000,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "",
"allocation_facespace_id": null,
"campaign_id": 392,
"campaign_redirect_url": "flyerbee.com",
"file_type": null,
"campaign_brief": "Test",
"campaign_created_at": "2017-07-03T11:44:52.464Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T13:33:04.034Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 747,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 0,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-07-17T14:00:00.000Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": 1004,
"file_mime": null,
"campaign_uid": "8C8E-45AB-B28F",
"file_name": null,
"campaign_state": "campaign_state/open",
"job_workorder_id": 1004,
"distribution_date_end": "2017-07-10T17:23:36.927Z",
"campaign_name": "New campaign 2",
"campaign_budget": 0,
"distribution_beacon_content": "",
"allocation_id": 1526,
"distribution_brief": "",
"allocation_facespace_id": 1075,
"campaign_id": 394,
"campaign_redirect_url": "",
"file_type": null,
"campaign_brief": "TEST",
"campaign_created_at": "2017-07-03T15:12:33.450Z",
"workorder_created_at": "2017-07-03T15:15:36.485Z",
"allocation_entity_id": 1562,
"distribution_created_at": "2017-07-03T15:12:53.570Z",
"allocation_date_end": "2017-07-10T17:23:36.927Z",
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": null,
"file_size": null,
"job_created_at": "2017-07-03T15:15:36.485Z",
"workorder_assigned_pdc_id": 347,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": "2017-07-03T15:15:36.485Z",
"distribution_id": 749,
"file_created_at": null,
"job_state": "jobstate/open",
"distribution_quantity": 0,
"allocation_state": "allocation_state/reserved",
"file_id": null,
"workorder_status": "workorder_status/initial",
"job_user_id": null,
"workorder_allocations_id": 1526,
"allocation_date_start": "2017-07-03T17:23:36.927Z",
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": 1000,
"campaign_image_id": null,
"distribution_date_start": "2017-07-03T17:23:36.927Z"
},
{
"file_source_identifier": null,
"file_creator_id": null,
"workorder_id": null,
"file_mime": null,
"campaign_uid": "8C8E-45AB-B28F",
"file_name": null,
"campaign_state": "campaign_state/open",
"job_workorder_id": null,
"distribution_date_end": "2017-07-10T15:23:36.927Z",
"campaign_name": "New campaign 2",
"campaign_budget": 0,
"distribution_beacon_content": "",
"allocation_id": null,
"distribution_brief": "PLEASE DO THIS... MISSING THE TARGETING",
"allocation_facespace_id": null,
"campaign_id": 394,
"campaign_redirect_url": "",
"file_type": null,
"campaign_brief": "TEST",
"campaign_created_at": "2017-07-03T15:12:33.450Z",
"workorder_created_at": null,
"allocation_entity_id": null,
"distribution_created_at": "2017-07-03T15:15:36.485Z",
"allocation_date_end": null,
"file_origin_name": null,
"campaign_customer_id": 1563,
"distribution_partner_id": 1571,
"file_size": null,
"job_created_at": null,
"workorder_assigned_pdc_id": null,
"campaign_user_id": 1804,
"file_status": null,
"file_location": null,
"allocation_created_at": null,
"distribution_id": 750,
"file_created_at": null,
"job_state": null,
"distribution_quantity": 0,
"allocation_state": null,
"file_id": null,
"workorder_status": null,
"job_user_id": null,
"workorder_allocations_id": null,
"allocation_date_start": null,
"campaign_pdc_id": 1562,
"campaign_person_id": 1811,
"job_id": null,
"campaign_image_id": null,
"distribution_date_start": "2017-07-03T15:23:36.927Z"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment