$everything is not working in Azure FHIR Service. Any ideas why?
We have uploaded this file https://github.com/synthetichealth/synthea-sample-data/blob/master/downloads/synthea_sample_data_fhir_r4_nov2021.zip to FHIR Service and per documentation $everything is supported - https://learn.microsoft.com/en-us/azure/healthcare-apis/fhir/fhir-features-supported
When I am trying to query using $everything resource only patient resource is returned while all patients have encounters & conditions attached. But those are not returning.
Unable to understand why $everything is not working and if there is anything special that needs to be done to make this work.
Azure Health Data Services
-
Dillon Silzer 54,831 Reputation points
2023-07-04T00:32:13.9366667+00:00 Can you provide your query string?
Just a thought, have you checked how to use the $everything when making API calls?
-
Pankaj Kumar 0 Reputation points
2023-07-04T19:37:33.1466667+00:00 Hi @Dillon Silzer - Thanks. I did check that document and here is my query {{fhirurl}}/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a/$everything
However, this generates below output which is just the patient record with other resources attached to the patient are missing. I can query these other resource types (like condition or encounter) for this patient and they are there in FHIR service. Just not returning with $everything.
{ "resourceType": "Bundle", "id": "f7c179f706fc41759810b73eaf847660", "meta": { "lastUpdated": "2023-07-04T19:35:13.6975234+00:00" }, "type": "searchset", "link": [ { "relation": "next", "url": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a/$everything?ct=NMkxCoRADAXQu6S2cUs7sRIsBla2DxgwOPzATGYb9WQWHskriIWvfddx%2Fj%2FbSmHmLNTUFfVwSeDYGVxR2NUw2iKgBiXGirqSksC%2FIm3MNiiWfnov8FOBXQX%2Bk5TV8CzVtN8AAAD%2F%2Fw%3D%3D" }, { "relation": "self", "url": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a/$everything" } ], "entry": [ { "fullUrl": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a", "resource": { "resourceType": "Patient", "id": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a", "meta": { "versionId": "1", "lastUpdated": "2023-06-24T20:29:53.768+00:00", "profile": [ "http://hl7.org/fhir/us/core/StructureDefinition/us-core-patient" ] }, "text": { "status": "generated", "div": "<div xmlns=\"http://www.w3.org/1999/xhtml\">Generated by <a href=\"https://github.com/synthetichealth/synthea\">Synthea</a>.Version identifier: master-branch-latest-7-gcc27279b\n . Person seed: 3214097265926879448 Population seed: 0</div>" }, "extension": [ { "extension": [ { "url": "ombCategory", "valueCoding": { "system": "urn:oid:2.16.840.1.113883.6.238", "code": "2106-3", "display": "White" } }, { "url": "text", "valueString": "White" } ], "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-race" }, { "extension": [ { "url": "ombCategory", "valueCoding": { "system": "urn:oid:2.16.840.1.113883.6.238", "code": "2135-2", "display": "Hispanic or Latino" } }, { "url": "text", "valueString": "Hispanic or Latino" } ], "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-ethnicity" }, { "url": "http://hl7.org/fhir/StructureDefinition/patient-mothersMaidenName", "valueString": "Clara183 Páez758" }, { "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-birthsex", "valueCode": "M" }, { "url": "http://hl7.org/fhir/StructureDefinition/patient-birthPlace", "valueAddress": { "city": "Caguas", "state": "Puerto Rico", "country": "PR" } }, { "url": "http://synthetichealth.github.io/synthea/disability-adjusted-life-years", "valueDecimal": 0.0 }, { "url": "http://synthetichealth.github.io/synthea/quality-adjusted-life-years", "valueDecimal": 13.0 } ], "identifier": [ { "system": "https://github.com/synthetichealth/synthea", "value": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a" }, { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "MR", "display": "Medical Record Number" } ], "text": "Medical Record Number" }, "system": "http://hospital.smarthealthit.org", "value": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a" }, { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "SS", "display": "Social Security Number" } ], "text": "Social Security Number" }, "system": "http://hl7.org/fhir/sid/us-ssn", "value": "999-28-5066" } ], "name": [ { "use": "official", "family": "Tijerina14", "given": [ "Javier97" ] } ], "telecom": [ { "system": "phone", "value": "555-244-1216", "use": "home" } ], "gender": "male", "birthDate": "2007-05-08", "address": [ { "extension": [ { "extension": [ { "url": "latitude", "valueDecimal": 42.48956380275285 }, { "url": "longitude", "valueDecimal": -70.94913353131781 } ], "url": "http://hl7.org/fhir/StructureDefinition/geolocation" } ], "line": [ "446 Jast Mission Unit 87" ], "city": "Lynn", "state": "MA", "postalCode": "01906", "country": "US" } ], "maritalStatus": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-MaritalStatus", "code": "S", "display": "Never Married" } ], "text": "Never Married" }, "multipleBirthBoolean": false, "communication": [ { "language": { "coding": [ { "system": "urn:ietf:bcp:47", "code": "es", "display": "Spanish" } ], "text": "Spanish" } } ] }, "search": { "mode": "match" } } ] }
-
Dillon Silzer 54,831 Reputation points
2023-07-04T20:58:31.68+00:00 Just curious, what if you use the year range:
GET {FHIRURL}/Patient/{ID}/$everything?start=2010&end=2023
-
Pankaj Kumar 0 Reputation points
2023-07-04T23:39:43.97+00:00 Tried it and same result. Got below
{ "resourceType": "Bundle", "id": "e8418411d9c99322f5a60a2ba8078574", "meta": { "lastUpdated": "2023-07-04T23:39:09.6386461+00:00" }, "type": "searchset", "link": [ { "relation": "next", "url": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a/$everything?start=2010&end=2023&ct=NMkxCoRADAXQu6S2cUs7sRIsBla2DxgwOPzATGYb9WQWHskriIWvfddx%2Fj%2FbSmHmLNTUFfVwSeDYGVxR2NUw2iKgBiXGirqSksC%2FIm3MNiiWfnov8FOBXQX%2Bk5TV8CzVtN8AAAD%2F%2Fw%3D%3D" }, { "relation": "self", "url": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a/$everything?start=2010&end=2023" } ], "entry": [ { "fullUrl": "https://relicehr-sample1.fhir.azurehealthcareapis.com/Patient/9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a", "resource": { "resourceType": "Patient", "id": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a", "meta": { "versionId": "1", "lastUpdated": "2023-06-24T20:29:53.768+00:00", "profile": [ "http://hl7.org/fhir/us/core/StructureDefinition/us-core-patient" ] }, "text": { "status": "generated", "div": "<div xmlns=\"http://www.w3.org/1999/xhtml\">Generated by <a href=\"https://github.com/synthetichealth/synthea\">Synthea</a>.Version identifier: master-branch-latest-7-gcc27279b\n . Person seed: 3214097265926879448 Population seed: 0</div>" }, "extension": [ { "extension": [ { "url": "ombCategory", "valueCoding": { "system": "urn:oid:2.16.840.1.113883.6.238", "code": "2106-3", "display": "White" } }, { "url": "text", "valueString": "White" } ], "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-race" }, { "extension": [ { "url": "ombCategory", "valueCoding": { "system": "urn:oid:2.16.840.1.113883.6.238", "code": "2135-2", "display": "Hispanic or Latino" } }, { "url": "text", "valueString": "Hispanic or Latino" } ], "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-ethnicity" }, { "url": "http://hl7.org/fhir/StructureDefinition/patient-mothersMaidenName", "valueString": "Clara183 Páez758" }, { "url": "http://hl7.org/fhir/us/core/StructureDefinition/us-core-birthsex", "valueCode": "M" }, { "url": "http://hl7.org/fhir/StructureDefinition/patient-birthPlace", "valueAddress": { "city": "Caguas", "state": "Puerto Rico", "country": "PR" } }, { "url": "http://synthetichealth.github.io/synthea/disability-adjusted-life-years", "valueDecimal": 0.0 }, { "url": "http://synthetichealth.github.io/synthea/quality-adjusted-life-years", "valueDecimal": 13.0 } ], "identifier": [ { "system": "https://github.com/synthetichealth/synthea", "value": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a" }, { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "MR", "display": "Medical Record Number" } ], "text": "Medical Record Number" }, "system": "http://hospital.smarthealthit.org", "value": "9ccd0d4f-f8f2-34a4-4ba9-9b9b92c6370a" }, { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "SS", "display": "Social Security Number" } ], "text": "Social Security Number" }, "system": "http://hl7.org/fhir/sid/us-ssn", "value": "999-28-5066" } ], "name": [ { "use": "official", "family": "Tijerina14", "given": [ "Javier97" ] } ], "telecom": [ { "system": "phone", "value": "555-244-1216", "use": "home" } ], "gender": "male", "birthDate": "2007-05-08", "address": [ { "extension": [ { "extension": [ { "url": "latitude", "valueDecimal": 42.48956380275285 }, { "url": "longitude", "valueDecimal": -70.94913353131781 } ], "url": "http://hl7.org/fhir/StructureDefinition/geolocation" } ], "line": [ "446 Jast Mission Unit 87" ], "city": "Lynn", "state": "MA", "postalCode": "01906", "country": "US" } ], "maritalStatus": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-MaritalStatus", "code": "S", "display": "Never Married" } ], "text": "Never Married" }, "multipleBirthBoolean": false, "communication": [ { "language": { "coding": [ { "system": "urn:ietf:bcp:47", "code": "es", "display": "Spanish" } ], "text": "Spanish" } } ] }, "search": { "mode": "match" } } ] }
Sign in to comment