Rohini Sanjay Ratnakar Posted January 17, 2019 Share Posted January 17, 2019 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 More sharing options...
Julio Gimenes Posted January 24, 2019 Share Posted January 24, 2019 Do you have TIBCO ActiveMatrix BusinessWorks Plug-in for REST and JSON installed If yes, you can use Tools (alt+t) > JSON Tools > Generate XML schema from json. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now