New post
AllAccepted answers
Luis Angel Pére... · Oct 6, 2023

Well, in theory if you define the identifier in the request section and define the method as "PUT" the server should create the organization if it doesn't exist or updated if it do.

<?xml version="1.0" encoding="UTF-8"?>
<Bundle xmlns="http://hl7.org/fhir">
    <type value="transaction"> </type>
    <entry>
        <resource>
            <Organization>
                <id value="17C7D86E-664F-4FE2-91D7-AF9A8E47311E"></id>
                <text>
                    <status value="generated"/>
                    <div xmlns="http://www.w3.org/1999/xhtml"> LITTLE CLINIC 2000 PATIENT DRIVE ANN
                        ARBOR MI US - NOI # 888333111 </div>
                </text>
                <identifier>
                    <system value="www.nationalorgidentifier.gov"/>
                    <value value="888333111"/>

                </identifier>
                <name value="LITTLE CLINIC"/>
                <address>
                    <line value="2000 CLINIC DRIVE"/>
                    <city value="ANN ARBOR"/>
                    <state value="MI"/>
                    <country value="US"/>
              </address>
            </Organization>
        </resource>
        <request>
            <method value="PUT"/>
            <url value="Organization?identifier=www.nationalorgidentifier.gov|888333111"/>
        </request>
    </entry>
    <entry>
        <resource>
            <Patient>
                <text>
                    <status value="generated"/>
                    <div xmlns="http://www.w3.org/1999/xhtml"> EVERYWOMAN EVE 2000 PATIENT DRIVE ANN
                        ARBOR MI MPI #12312311 </div>

                </text>
                <identifier>
                    <system value="www.mypatientidentifier.com"/>
                    <value value="12312311"/>
                </identifier>
                <name>
                    <family value="EVERYWOMAN"/>
                    <given value="EVE"/>
                </name>
                <address>
                    <line value="2000 PATIENT DRIVE"/>
                    <city value="ANN ARBOR"/>
                    <state value="MI"/>
                    <country value="US"/>
                </address>
                <managingOrganization>
                    <reference value="Organization/17C7D86E-664F-4FE2-91D7-AF9A8E47311E">
                        
                    </reference>   
                </managingOrganization>
               </Patient>

        </resource>
        <request>
            <method value="PUT"/>
            <url value="Patient?identifier=www.mypatientidentifier.com|12312311"/>
        </request>
    </entry>
</Bundle>

But this is the theory...not sure if it will work for your FHIR server.

Luis Angel Pére... · Sep 18, 2023

You are right, you have to create the properties before to use %FindDocuments...BUT...it doesn't work for arrays of data. I've found this answer to a similar question:

https://community.intersystems.com/post/how-query-data-docdb-through-pyt...

I was testing the behaviour with this example:

  DO db.%CreateProperty("type","%String","$.PhoneNumber.type")
    

  SET dynAbObj = {
   "FullName":"John Smith",
   "FirstName":"John",
   "Address":{
              "street":"101 Main Street",
              "city":"Mapleville",
              "state":"NY",
              "postal code":10234
             },
   "PhoneNumber":
              [
               {"type":"home","number":"212-456-9876"},
               {"type":"cell","number":"401-123-4567"},
               {"type":"work","number":"212-444-5000"}
              ]
  }
  $$$TRACE(dynAbObj.%ToJSON())
  SET jstring = dynAbObj.%ToJSON() // dynamic abstract object to JSON string
  DO db.%FromJSON(jstring)   // JSON string inserted into document database
  $$$TRACE(db.%FindDocuments(["type","cell","="]).%ToJSON())
  $$$TRACE(db.%FindDocuments(["type","home","="]).%ToJSON())

This is the answer for the first search:

{"sqlcode":100,"message":null,"content":[]}

And this is the answer for the second search:

{"sqlcode":100,"message":null,"content":[{"%Doc":"{\"FullName\":\"John Smith\",\"FirstName\":\"John\",\"Address\":{\"street\":\"101 Main Street\",\"city\":\"Mapleville\",\"state\":\"NY\",\"postal code\":10234},\"PhoneNumber\":[{\"type\":\"home\",\"number\":\"212-456-9876\"},{\"type\":\"cell\",\"number\":\"401-123-4567\"},{\"type\":\"work\",\"number\":\"212-444-5000\"}]}","%DocumentId":"1","%LastModified":"2023-09-18 10:13:30.694"}]}

As you can see, it only works fine for the first value of the array, the definition of the property doesn't allow to define an array of values.