IBM Support

JSON Member Search Example for REST

Question & Answer


Question

We use IBM Infosphere Master Data Service to manage our data and would like the ability to query it with JSON web services but the documentation is not clear on what the JSON request should look like for a Member Search via REST. Do you have a sample request object that I can leverage to build my own solution?

Answer

Below is an example of a JSON Member Search request and how to test it via curl from the command line.

JSON Request Object:
{
"attrListMap": {
"SSN": [{"fieldMap": {"idnumber": "555667777", "idissuer": "SSA" }}],
"LGLNAME": [{"fieldMap": {"onmfirst": "John", "onmlast": "Smith" }}],
"BIRTHDT": [{"fieldMap": {"dateval": "1912-02-14" }}],
"HOMEPHON": [{"fieldMap": {"phnumber": "101-123-7654" }}],
}
}

Curl Command:
curl -i -H "Content-Type: application/json" -H "Accept: application/json" -H "Authorization: xmlc c3lzdGVtOnN5c3RlbQ==" -X POST -d @search.json localhost/madappsvcs/rest/record/?entType=id

In this example, the 4 attributes that I am using to search have the following attrCodes: SSN, BIRTHDT, HOMEPHON, LGLNAME. You will need to adjust these to match your configuration. The fields used within the fieldMaps may be changed as well to match your Attribute Types. The JSON request was saved to a file called search.json which is then passed in as data to the curl command via the -d option.

[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

MDS;Master Data Service;MDM;MDMSE;Master Data Management;IBM Infosphere Master Data Service;MDM Standard Edition;MDM Hybrid Edition;Initiate;Initiate Systems

Document Information

Modified date:
16 June 2018

UID

swg21621384