Your question may already have an answer on the community forum. Please search for related topics, and then read through the guidelines before creating a new topic.
Hereâs an outline with best practices for making your inquiry.
My question:
patientProcedures,practiceProcedures,visits are nested arrays with columns like
{
id:123
,type:âsome stringâ
,url :âSome http Urlâ
}
But in most of my Json response they are empty .I want to filter and fetch only records which have
not null array values (patientProcedures,practiceProcedures,visits) so that i can test loading them in a database
Details (like screenshots):
I have attached Json with two records for example but my json has 25k records
{
âstatusCodeâ: 200,
âdataâ: [
{
âtypeâ: âAppointmentV1â,
âlastModifiedâ: â2016-07-08T16:53:13.657Zâ,
âdurationâ: 60,
âstatusIdâ: 5,
âpatientProceduresâ: ,
âpracticeProceduresâ: ,
âvisitsâ: ,
âidâ: â7000002983226â,
âtitleâ: âAppointmentâ,
âstartâ: â2002-08-30T14:30:00.000Zâ,
âcreatedâ: â2016-04-20T05:27:41.840Zâ,
âendâ: â2002-08-30T15:30:00.000Zâ,
âneedsFollowUpâ: false,
âneedsPremedicateâ: false,
âstatusâ: âCOMPLETEDâ,
ânoteâ: âaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaâ,
âotherâ: âCCAdultâ,
âbookedOnlineâ: false,
âpatientâ: {
âidâ: â7000001065834â,
âtypeâ: âPatientV1â,
âurlâ: âTestUrlâ
},
âlocationâ: {
âidâ: â7000000000260â,
âtypeâ: âLocationV1â,
âurlâ: âUrl1â
},
âproviderâ: {
âidâ: â7000000000774â,
âtypeâ: âProviderV1â,
âurlâ: âUrl2â
},
âoperatoryâ: {
âidâ: â7000000000550â,
âtypeâ: âOperatoryV1â,
âurlâ: âUrl3â
}
},
{
âtypeâ: âAppointmentV1â,
âlastModifiedâ: â2016-07-08T16:53:13.657Zâ,
âdurationâ: 60,
âstatusIdâ: 5,
âpatientProceduresâ: ,
âpracticeProceduresâ: ,
âvisitsâ: ,
âidâ: â7000002983227â,
âtitleâ: âAppointmentâ,
âstartâ: â2002-08-02T17:30:00.000Zâ,
âcreatedâ: â2016-04-20T05:27:41.840Zâ,
âendâ: â2002-08-02T18:30:00.000Zâ,
âneedsFollowUpâ: false,
âneedsPremedicateâ: false,
âstatusâ: âCOMPLETEDâ,
ânoteâ: âaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaâ,
âotherâ: âCCAdultâ,
âbookedOnlineâ: false,
âpatientâ: {
âidâ: â7000001066365â,
âtypeâ: âPatientV1â,
âurlâ: âUrl4â
},
âlocationâ: {
âidâ: â7000000000260â,
âtypeâ: âLocationV1â,
âurlâ: âUrl5â
},
âproviderâ: {
âidâ: â7000000000774â,
âtypeâ: âProviderV1â,
âurlâ: âUrl6â
},
âoperatoryâ: {
âidâ: â7000000000550â,
âtypeâ: âOperatoryV1â,
âurlâ: âUrl7â
}
}
],
âmetaâ: {
âpaginationâ: {
âlimitâ: 2,
âoffsetâ: 0,
âtotalâ: 23895
}
}
}
How I found the problem:
Iâve already tried: