Skip to content

Instantly share code, notes, and snippets.

@Rohithzr

Rohithzr/sample.json

Created October 21, 2019 06:08
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 Rohithzr/67bce44511e7b94efe010d94e9eff35a to your computer and use it in GitHub Desktop.
Save Rohithzr/67bce44511e7b94efe010d94e9eff35a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sample.json
{
"_id" : ObjectId("5a61a868454d53e2753967ed"),
"invoiceId" : "171112",
"__v" : 0,
"ship_date" : ISODate("2017-11-30T00:00:00.000Z"),
"name" : "Name",
"sections" : [
{
"servicePeriod" : {
"startDate" : ISODate("2017-11-01T00:00:00.000Z"),
"endDate" : ISODate("2017-11-30T23:59:59.999Z")
},
"servicePeriodEdited" : {
"startDate" : null,
"endDate" : null
},
"people" : [],
"amount" : 82801,
"expenses" : -214.6,
"name" : "Nov 2017",
"_id" : ObjectId("5dad4a2b896a660004c939c7"),
"account" : "Revenue",
"invoiceId" : "171112",
"invoiceWorkstream" : "171112",
"split" : "A/R Keystone",
"paid" : true,
"project" : ObjectId("59c2206b34e0f4001dc948fe"),
"account_type" : "Income",
"quickbooksId" : "15BA93C-1512141845",
"subSections" : [
{
"amount" : -5511,
"expenses" : 88097.4,
"name" : "Over payment client",
"_id" : ObjectId("5dad4a2b896a660004c939c8"),
"account" : "Discount",
"split" : "A/R ",
"account_type" : "Account type not found",
"quickbooksId" : "15BA93C-1512141845"
}
],
"payments" : [
{
"_id" : ObjectId("5dad4a2b896a660004c939ca"),
"quickbooksId" : "15BA93C-1512141845",
"transactionId" : "15FB418-1519912467",
"paidCustomerFullname" : "Survey",
"transactionCreatedDate" : ISODate("2018-03-01T05:54:27.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112",
"paidARAccount" : "A/R Keystone",
"transactionNum" : 53059,
"paidAmount" : 82586.4,
"paidDepositToAccount" : "Checking"
},
{
"_id" : ObjectId("5dad4a2b896a660004c939c9"),
"quickbooksId" : "15BA93C-1512141845",
"transactionId" : "15FB418-1519912467",
"paidCustomerFullname" : "urvey",
"transactionCreatedDate" : ISODate("2018-03-01T05:54:27.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112",
"paidARAccount" : "A/R Keystone",
"transactionNum" : 53059,
"paidAmount" : 82586.4,
"paidDepositToAccount" : "Private Bank - Checking"
}
],
"createdDate" : ISODate("2017-12-01T07:24:05.000Z"),
"earnedDate" : ISODate("2017-11-30T00:00:00.000Z")
},
{
"servicePeriod" : {
"startDate" : ISODate("2017-11-01T00:00:00.000Z"),
"endDate" : ISODate("2017-11-30T23:59:59.999Z")
},
"servicePeriodEdited" : {
"startDate" : null,
"endDate" : null
},
"people" : [],
"amount" : 38072,
"expenses" : 0,
"name" : "Nov 2017",
"_id" : ObjectId("5dad4a2b896a660004c939c5"),
"account" : "Revenue",
"invoiceId" : "171112",
"invoiceWorkstream" : "171112",
"split" : "A/R Keystone",
"paid" : true,
"project" : ObjectId("58de13d7cae6e30011c88fc3"),
"account_type" : "Income",
"quickbooksId" : "15BA94B-1512142201",
"subSections" : [],
"payments" : [
{
"_id" : ObjectId("5dad4a2b896a660004c939c6"),
"quickbooksId" : "15BA94B-1512142201",
"transactionId" : "15FB45F-1519912488",
"paidCustomerFullname" : "mages",
"transactionCreatedDate" : ISODate("2018-03-01T05:54:48.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112",
"paidARAccount" : "A/R Keystone",
"transactionNum" : 53060,
"paidAmount" : 38072,
"paidDepositToAccount" : "Private Bank - Checking"
}
],
"createdDate" : ISODate("2017-12-01T07:30:01.000Z"),
"earnedDate" : ISODate("2017-11-30T00:00:00.000Z")
},
{
"servicePeriod" : {
"startDate" : ISODate("2017-11-01T00:00:00.000Z"),
"endDate" : ISODate("2017-11-30T23:59:59.999Z")
},
"servicePeriodEdited" : {
"startDate" : null,
"endDate" : null
},
"people" : [],
"amount" : 1260,
"expenses" : 0,
"name" : "Nov 2017",
"_id" : ObjectId("5dad4a2b896a660004c939c3"),
"account" : "Revenue",
"invoiceId" : "171112",
"invoiceWorkstream" : "171112",
"split" : "A/R Keystone",
"paid" : true,
"project" : ObjectId("59969efcfe6a7d001c452f48"),
"account_type" : "Income",
"quickbooksId" : "15BF477-1512658713",
"subSections" : [],
"payments" : [
{
"_id" : ObjectId("5dad4a2b896a660004c939c4"),
"quickbooksId" : "15BF477-1512658713",
"transactionId" : "15FB464-1519912503",
"paidCustomerFullname" : " - Soffer",
"transactionCreatedDate" : ISODate("2018-03-01T05:55:03.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112",
"paidARAccount" : "A/R Keystone",
"transactionNum" : 53061,
"paidAmount" : 1260,
"paidDepositToAccount" : "Private Bank - Checking"
}
],
"createdDate" : ISODate("2017-12-07T06:58:33.000Z"),
"earnedDate" : ISODate("2017-11-30T00:00:00.000Z")
},
{
"servicePeriod" : {
"startDate" : ISODate("2017-11-01T00:00:00.000Z"),
"endDate" : ISODate("2017-11-30T23:59:59.999Z")
},
"servicePeriodEdited" : {
"startDate" : null,
"endDate" : null
},
"people" : [],
"amount" : 17312.5,
"expenses" : 0,
"name" : "hporet, 11/30/2017, 27.70 hrs @ 625",
"_id" : ObjectId("5dad4a2b896a660004c939c1"),
"account" : "Expert Revenue",
"invoiceId" : "171112p",
"invoiceWorkstream" : "171112p",
"split" : "A/R Passthru",
"paid" : true,
"project" : ObjectId("59c2206b34e0f4001dc948fe"),
"account_type" : "Other Income",
"quickbooksId" : "15DA888-1515793740",
"subSections" : [],
"payments" : [
{
"_id" : ObjectId("5dad4a2b896a660004c939c2"),
"quickbooksId" : "15DA888-1515793740",
"transactionId" : "15FB469-1519912529",
"paidCustomerFullname" : "Survey",
"transactionCreatedDate" : ISODate("2018-03-01T05:55:29.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112p",
"paidARAccount" : "A/R Passthru",
"transactionNum" : 53062,
"paidAmount" : 17312.5,
"paidDepositToAccount" : "Private Bank - Checking"
}
],
"createdDate" : ISODate("2018-01-12T13:49:00.000Z"),
"earnedDate" : ISODate("2017-11-30T00:00:00.000Z")
},
{
"servicePeriod" : {
"startDate" : ISODate("2017-11-01T00:00:00.000Z"),
"endDate" : ISODate("2017-11-30T23:59:59.999Z")
},
"servicePeriodEdited" : {
"startDate" : null,
"endDate" : null
},
"people" : [],
"amount" : 11475,
"expenses" : 0,
"name" : "dfranklyn, 11/30/2017, 17 hrs @ 675",
"_id" : ObjectId("5dad4a2b896a660004c939bf"),
"account" : "Expert Revenue",
"invoiceId" : "171112p",
"invoiceWorkstream" : "171112p",
"split" : "A/R Passthru",
"paid" : true,
"project" : ObjectId("59c2206b34e0f4001dc948fe"),
"account_type" : "Other Income",
"quickbooksId" : "15F270F-1518799237",
"subSections" : [],
"payments" : [
{
"_id" : ObjectId("5dad4a2b896a660004c939c0"),
"quickbooksId" : "15F270F-1518799237",
"transactionId" : "15FB46E-1519912547",
"paidCustomerFullname" : "vey",
"transactionCreatedDate" : ISODate("2018-03-01T05:55:47.000Z"),
"modifiedDate" : ISODate("2018-04-03T06:33:49.000Z"),
"paidDate" : ISODate("2018-03-01T00:00:00.000Z"),
"paidInvoiceNum" : "171112p",
"paidARAccount" : "A/R Passthru",
"transactionNum" : 53063,
"paidAmount" : 11475,
"paidDepositToAccount" : "Private Bank - Checking"
}
],
"createdDate" : ISODate("2018-02-16T08:40:37.000Z"),
"earnedDate" : ISODate("2017-11-30T00:00:00.000Z"),
"expert" : ObjectId("58daa8fd82f38b00119a2b26")
}
],
"terms" : "Net 30",
"due_date" : ISODate("2018-02-11T00:00:00.000Z"),
"submitted_date" : ISODate("2018-01-12T00:00:00.000Z"),
"projects" : [
ObjectId("59c2206b34e0f4001dc948fe"),
ObjectId("58de13d7cae6e30011c88fc3"),
ObjectId("59969efcfe6a7d001c452f48")
],
"invoiceStreamId" : ObjectId("5a61a899dd83490004813896"),
"paid" : true,
"status" : "paid"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment