Jump to content
We have recently updated our Privacy Statement, available here ×

Schema creation


Recommended Posts

I need to create a schema for the below JSON structure in TIBCO BW. Could you please assist

{

"query": {

"bool": {

"must": [

{

"match": {

"providerInfo.planId": "PL001"

}

}

],

"should": [

{

"match": {

"providerLocations.provaddress.zip": "453601"

}

},

{

"match": {

"providerLocations.provaddress.city": "ABC"

}

},

{

"match": {

"providerLocations.provaddress.state": "XYZ"

}

},

{

"match": {

"providerInfo.weekendavailability": "Yes"

}

},

{

"query_string": {

"query": "P001 P002"

}

},

{

"match": {

"providerInfo.providerFullName": "Jason Quill"

}

},

{

"match": {

"providerInfo.firstName": "Jason"

}

},

{

"match": {

"providerInfo.lastName": "Quill"

}

},

{

"match": {

"providerInfo.npi": "231"

}

},

{

"match": {

"providerInfo.speciality": "New"

}

},

{

"match": {

"providerInfo.providerEntity": "Fixed"

}

},

{

"match": {

"providerInfo.networkType": "Intra"

}

},

{

"match": {

"practitionerDetails.isPCP": "Yes"

}

},

{

"match": {

"providerInfo.gender": "Male"

}

},

{

"query_string": {

"query": "English OR French",

"fields": ["providerInfo.languagesSpoken"]

}

},

{

"match": {

"providerLocations.provaddress.handicapenabled": "Yes"

}

},

{

"match": {

"providerInfo.providerQualityRating": 6

}

},

{

"match": {

"providerInfo.acceptingNewPatients": "Yes"

}

},

{

"match": {

"providerInfo.providerEffectiveDate": "12/31/2017"

}

},

{

"match": {

"providerInfo.providerType": "New"

}

},

{

"match": {

"affiliationDetails.groupAffiliations.affiliationname": "GA1"

}

},

{

"match": {

"affiliationDetails.hospitalAffiliations.affiliationname": "HA1"

}

},

{

"match": {

"providerNetwork.networkaffiliation": "NA1"

}

},

{

"match": {

"providerInfo.providerId": "FP001 OR FP002"

}

}

]

}

},

"sort": [

{

"providerInfo.providerQualityRating": {

"order": "desc"

}

}

],

"_source":

{

"includes": [

"providerSpecialties",

"providerLocations",

"networkDetails.networkId",

"networkDetails.networkIdType",

"networkDetails.networkTier",

"networkDetails.pcpIndicator",

"practitionerDetails",

"providerInfo.providerQualityRating",

"providerInfo.providerId",

"providerInfo.providerNPI",

"providerInfo.providerEntity",

"providerInfo.providerType",

"providerInfo.providerFullName",

"providerInfo.providerFirstName",

"providerInfo.providerMiddleName",

"providerInfo.providerLastName",

"providerInfo.unAvailableDate",

"providerInfo.providerStatus",

"providerInfo.cciProviderId",

"providerInfo.providerArray",

"providerInfo.cpfId",

"providerInfo.facetsProvId",

"providerInfo.truProvId"

],

"excludes": [

"providerLocations.officehours",

"providerLocations.servicesrendered",

"providerLocations.scprovideraddressinfo",

"practitionerDetails.isPCP",

"practitionerDetails.practitionerTypeCode",

"practitionerDetails.practitionerTypeDesc",

"providerSpecialties.subspeciality",

"provMedCenterInfo.locationkey",

"providerLocations.locuniquekey",

"providerLocations.provideratlocationfirstname",

"providerLocations.providerdemographickey",

"providerLocations.provideratlocationlastname",

"providerLocations.provideratlocationmiddlename",

"providerLocations.provaddress.etldateupdated", "providerLocations.provaddress.etldatedeleted",

"providerLocations.provaddress.ghippocountycode",

"providerLocations.provaddress.addressstatus",

"providerLocations.provaddress.addressprocesseddate"]

}

}

Link to comment
Share on other sites

×
×
  • Create New...