Text Search
By using text search, you can search for human recognizable terms similar to web search engines. Text in a record is indexed and stored as key terms in a high performance and quick retrieval data structure called the Index.
Text search requires parameters and finds matches that do not match exactly. However, they can have small variations in the data. Matching is an additional functionality built on the fuzzy search capability that provides the best matching repository record with the specified input record. Specify weight of an attribute to provide more weightage for matching records in the request example. Enter a decimal number between 0.00 to 1. To know more about the matching process and for the text index configuration, refer to the chapter, "Search and Matching" in TIBCO MDM System Administration.
HTTP Method | ||||
Endpoint URL | See Endpoint | |||
Resource | /records/textSearch | |||
Request Parameters | Specify the following parameters: | |||
Name | Description | Type | Data Type | |
Required | ||||
entityName | Name of the index entity | body | string | |
similarityScore | The value for the similarity search for the text | body | number (float) | |
SearchString | Name of text that you want to search | body | string | |
startIndex | Represents the starting sequential number of matching record that you want to display in the response. For example, if a repository contains twenty matching records and you want to view the matching record from fifth to twenty. You can specify "startIndex":"5". The default value is 0. | body | integer (int32) | |
endIndex | Represents the end sequential number of matching record that you want to display in the response. For example, if a repository contains twenty matching records and you want to view the matching record from fifth to twenty. You can specify "endIndex":"20". The default value is 20 | body | integer (int32) | |
repositoryName | Name of the repository | body | string | |
repository | Attributes specified in the repository | body | string | |
Media Type | application/json | |||
Request Model |
{ "entityName": "string", "similarityScore": 0, "searchString": "string", "startIndex": 0, "endIndex": 0, "repositoryName": "string", "repository": { "name": "string", "productKey": 0, "attributes": [ { "name": "string", "value": [ {} ], "weight": "string" } ], "multivalueAttributes": { "additionalProp1": [ {} ], "additionalProp2": [ {} ], "additionalProp3": [ {} ] }, "relationships": [ { "name": "string", "count": 0, "checkExistence": true, "repository": { "name": "string", "productKey": 0, "attributes": [ { "name": "string", "value": [ {} ], "weight": "string" } ] } } ] } } |
|||
Response Model |
{ "records": [ { "productId": "string", "productIdExt": "string", "productKeyId": "string", "version": "string", "state": "string", "effectiveDate": "string", "attributes": [ { "name": "string", "value": "string", "displayName": "string", "multivalues": [ {} ], "multivalue": false, "id": 0, "groupName": "string" } ], "repositoryName": "string", "relationships": { "relationshipAttributes": [ { "name": "string", "value": "string", "displayName": "string", "multivalues": [ {} ], "multivalue": false, "id": 0, "groupName": "string" } ], "targetRecord": {} }, "deleted": false } ], "totalCount": 0 } |
|||
Request Example | See Request Examples | |||
Response Example | See Response Examples | |||
Success Response | Example:
Code: 200 successful operation |
|||
Error Response | If the response is unsuccessful, either of the following error code is displayed:
Example: Code: 400 Parameters required are missing OR Code: 404 Record not found OR Code: 500 Invalid Request For error code response, see Error Handling . |
Example Name | Examples |
---|---|
Attribute Based Search |
{ "entityName": "rest1", "similarityScore": "0.8", "repository": { "name": "ALLTypeA", "attributes": [ { "name": "ATA_STRING1", "value": [ "deshoom" ], "weight": "0.9" }, { "name": "ATA_INTEGER1", "value": [ "789" ], "weight": "1.0" } ], "relationships": [ { "name": "AAToAB", "repository": { "name": "ALLTypeB", "attributes": [ { "name": "ATA_STRING1", "value": [ "Abhi" ], "weight": "1.0" }, { "name": "ATA_AMOUNT1", "value": [ "982.233" ] } ] } } ] } } |
Free Form Search With Pagination |
{ "entityName":"rest1", "similarityScore":"0.8", "searchString":"demo1", "startIndex":"0", "endIndex":"25" } |
Free Form Search With Repository Name |
{ "repositoryName":"ALLTypeA", "similarityScore":"0.8", "searchString":"demo", "startIndex":"0", "endIndex":"25" } |
Example Name | Examples |
---|---|
Attribute Based Search |
{ "records": [ { "productId": "test1", "productIdExt": "test1", "productKeyId": "14002", "version": "1", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "0.98", "attributes": [ { "name": "PRODUCTID", "value": "test1", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "test1", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_URL1", "value": "", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_STRING1", "value": "deshoom", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "789", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_FILE1", "value": "", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DATE1", "value": "", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValue", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [], "groupName": "MultiValue", "matchingAttribute": false, "multivalue": true }, { "name": "GRP_LONG1", "value": "", "displayName": "GRP_LONG1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false }, { "name": "GRP_URL1", "value": "", "displayName": "GRP_URL1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false } ], "repositoryName": "ALLTYPEA", "relationships": {"AAToAB": [ { "relationshipAttributes": [ { "name": "REL_Long1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_URL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_STRING1", "value": "rrtest", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_INTEGER1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_BOOLEAN1", "value": "true", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_FILE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_AMOUNT1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DATE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_CUSDECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_TIMESTAMP1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false } ], "targetRecord": { "productId": "test2", "productIdExt": "test2", "productKeyId": "14003", "version": "2", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "", "attributes": [ { "name": "PRODUCTID", "value": "test2", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "test2", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_URL1", "value": "", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_STRING1", "value": "Abhishek", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "982.233", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_FILE1", "value": "", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DATE1", "value": "", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true } ], "repositoryName": "ALLTYPEB", "relationships": {}, "deleted": false } }]}, "deleted": false }], "totalCount": 1 } |
Free Form Search With Pagination |
{ "records": [ { "productId": "r1", "productIdExt": "r1", "productKeyId": "10002", "version": "2", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "1.0", "attributes": [ { "name": "PRODUCTID", "value": "r1", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r1", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "12345", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_URL1", "value": "http://www.linkedin.com", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_STRING1", "value": "demo", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "123", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "11.22", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_FILE1", "value": "Download?downloaddoc=master/34306/10002/32009/ATTACHMENTS/file1_1.txt", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "true", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DATE1", "value": "07/21/2017", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "2017-07-26 12:12:11.977", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "23.11", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "27651.2344", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [ "1872", "223" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [ "http://www.internet.com", "http://www.fild.com" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [ "demo1", "demo2" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": [ "file2.txt", "file3.txt" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [ "11.22", "12.333" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "false", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValue", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [ "1", "2" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [ "1.10", "0.20" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [ "07/28/2017", "07/14/2017" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [ "9182.23", "1625.32" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [ "2017-07-26 12:13:55.145", "2017-07-26 12:14:00.380" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "GRP_LONG1", "value": "", "displayName": "GRP_LONG1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false }, { "name": "GRP_URL1", "value": "", "displayName": "GRP_URL1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false } ], "repositoryName": "ALLTYPEA", "relationships": {"AAToAB": [ { "relationshipAttributes": [ { "name": "REL_Long1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_URL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_STRING1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_INTEGER1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_BOOLEAN1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_FILE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_AMOUNT1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DATE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_CUSDECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_TIMESTAMP1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false } ], "targetRecord": { "productId": "r2", "productIdExt": "r2", "productKeyId": "10003", "version": "2", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "", "attributes": [ { "name": "PRODUCTID", "value": "r2", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r2", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "182632", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_URL1", "value": "http://www.hfc.com", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_STRING1", "value": "r2demo", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "8172", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "7172.22", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_FILE1", "value": "Download?downloaddoc=master/34319/10003/32037/ATTACHMENTS/file4_1.txt", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "8172.22", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "2017-07-26 12:16:15.877", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DATE1", "value": "07/12/2017", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "true", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [ "8172", "2763" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [ "http://www.ind.com", "http://www.cms.com" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [ "de1", "de2" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": ["file5.txt"], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [ "1982.22", "82763.22" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "false", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [ "12", "13" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [ "4.40", "5.50" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [ "07/30/2017", "07/31/2017" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [ "9182.22", "263.22" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [ "2017-07-26 12:17:32.455", "2017-07-26 12:17:37.260" ], "groupName": "MultiValueB", "matchingAttribute": true, "multivalue": true } ], "repositoryName": "ALLTYPEB", "relationships": {"BC": [ { "relationshipAttributes": [], "targetRecord": { "productId": "r3", "productIdExt": "r3", "productKeyId": "10015", "version": "1", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "", "attributes": [ { "name": "PRODUCTID", "value": "r3", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r3", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_LONGC1", "value": "1728", "displayName": "AT_LONGC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_URLC1", "value": "http://www.google.com", "displayName": "AT_URLC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_STRINGC1", "value": "demo", "displayName": "AT_STRINGC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_INTEGERC1", "value": "", "displayName": "AT_INTEGERC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_AMOUNTC1", "value": "", "displayName": "AT_AMOUNTC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_BOOLEANC1", "value": "", "displayName": "AT_BOOLEANC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_FILEC1", "value": "", "displayName": "AT_FILEC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_DECIMALC1", "value": "", "displayName": "AT_DECIMALC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_CUSDECIMALC1", "value": "", "displayName": "AT_CUSDECIMALC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_DATEC1", "value": "", "displayName": "AT_DATEC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_TIMESTAMPC1", "value": "", "displayName": "AT_TIMESTAMPC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false } ], "repositoryName": "ALLTYPEC", "relationships": {}, "deleted": false } }]}, "deleted": false } }]}, "deleted": false }], "totalCount": 1 } |
Free Form Search With Repository Name |
{ "records": [ { "productId": "r1", "productIdExt": "r1", "productKeyId": "10002", "version": "2", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "1.0", "attributes": [ { "name": "PRODUCTID", "value": "r1", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r1", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "12345", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_URL1", "value": "http://www.linkedin.com", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_STRING1", "value": "demo", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "123", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "11.22", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_FILE1", "value": "Download?downloaddoc=master/34306/10002/32009/ATTACHMENTS/file1_1.txt", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "true", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_DATE1", "value": "07/21/2017", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "2017-07-26 12:12:11.977", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "23.11", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "27651.2344", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": true, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [ "1872", "223" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [ "http://www.internet.com", "http://www.fild.com" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [ "demo1", "demo2" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": [ "file2.txt", "file3.txt" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [ "11.22", "12.333" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "false", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValue", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [ "1", "2" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [ "1.10", "0.20" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [ "07/28/2017", "07/14/2017" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [ "9182.23", "1625.32" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [ "2017-07-26 12:13:55.145", "2017-07-26 12:14:00.380" ], "groupName": "MultiValue", "matchingAttribute": true, "multivalue": true }, { "name": "GRP_LONG1", "value": "", "displayName": "GRP_LONG1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false }, { "name": "GRP_URL1", "value": "", "displayName": "GRP_URL1", "multivalues": null, "groupName": "Group1", "matchingAttribute": false, "multivalue": false } ], "repositoryName": "ALLTYPEA", "relationships": {"AAToAB": [ { "relationshipAttributes": [ { "name": "REL_Long1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_URL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_STRING1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_INTEGER1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_BOOLEAN1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_FILE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_AMOUNT1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DATE1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_DECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_CUSDECIMAL1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false }, { "name": "REL_TIMESTAMP1", "value": "", "displayName": null, "multivalues": null, "groupName": null, "matchingAttribute": false, "multivalue": false } ], "targetRecord": { "productId": "r2", "productIdExt": "r2", "productKeyId": "10003", "version": "2", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "", "attributes": [ { "name": "PRODUCTID", "value": "r2", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r2", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_LONG1", "value": "182632", "displayName": "ATA_LONG1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_URL1", "value": "http://www.hfc.com", "displayName": "ATA_URL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_STRING1", "value": "r2demo", "displayName": "ATA_STRING1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_INTEGER1", "value": "8172", "displayName": "ATA_INTEGER1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_AMOUNT1", "value": "7172.22", "displayName": "ATA_AMOUNT1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_FILE1", "value": "Download?downloaddoc=master/34319/10003/32037/ATTACHMENTS/file4_1.txt", "displayName": "ATA_FILE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_CUSDECIMAL1", "value": "8172.22", "displayName": "ATA_CUSDECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DECIMAL1", "value": "", "displayName": "ATA_DECIMAL1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_TIMESTAMP1", "value": "2017-07-26 12:16:15.877", "displayName": "ATA_TIMESTAMP1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_DATE1", "value": "07/12/2017", "displayName": "ATA_DATE1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_BOOLEAN1", "value": "true", "displayName": "ATA_BOOLEAN1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_LONG1", "value": null, "displayName": "ATA_MV_LONG1", "multivalues": [ "8172", "2763" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_URL1", "value": null, "displayName": "ATA_MV_URL1", "multivalues": [ "http://www.ind.com", "http://www.cms.com" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_STRING1", "value": null, "displayName": "ATA_MV_STRING1", "multivalues": [ "de1", "de2" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_FILE1", "value": null, "displayName": "ATA_MV_FILE1", "multivalues": ["file5.txt"], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_AMOUNT1", "value": null, "displayName": "ATA_MV_AMOUNT1", "multivalues": [ "1982.22", "82763.22" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_BOOLEAN1", "value": "false", "displayName": "ATA_MV_BOOLEAN1", "multivalues": null, "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": false }, { "name": "ATA_MV_INTEGER1", "value": null, "displayName": "ATA_MV_INTEGER1", "multivalues": [ "12", "13" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DECIMAL1", "value": null, "displayName": "ATA_MV_DECIMAL1", "multivalues": [ "4.40", "5.50" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_DATE1", "value": null, "displayName": "ATA_MV_DATE1", "multivalues": [ "07/30/2017", "07/31/2017" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_CUSDECIMAL1", "value": null, "displayName": "ATA_MV_CUSDECIMAL1", "multivalues": [ "9182.22", "263.22" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true }, { "name": "ATA_MV_TIMESTAMP1", "value": null, "displayName": "ATA_MV_TIMESTAMP1", "multivalues": [ "2017-07-26 12:17:32.455", "2017-07-26 12:17:37.260" ], "groupName": "MultiValueB", "matchingAttribute": false, "multivalue": true } ], "repositoryName": "ALLTYPEB", "relationships": {"BC": [ { "relationshipAttributes": [], "targetRecord": { "productId": "r3", "productIdExt": "r3", "productKeyId": "10015", "version": "1", "state": "CONFIRMED", "isDeleted": false, "similarityScore": "", "attributes": [ { "name": "PRODUCTID", "value": "r3", "displayName": "Record ID", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "PRODUCTIDEXT", "value": "r3", "displayName": "Record ID Extension", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "CONTAINS", "value": "", "displayName": "Related Records", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_LONGC1", "value": "1728", "displayName": "AT_LONGC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_URLC1", "value": "http://www.google.com", "displayName": "AT_URLC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_STRINGC1", "value": "demo", "displayName": "AT_STRINGC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_INTEGERC1", "value": "", "displayName": "AT_INTEGERC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_AMOUNTC1", "value": "", "displayName": "AT_AMOUNTC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_BOOLEANC1", "value": "", "displayName": "AT_BOOLEANC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_FILEC1", "value": "", "displayName": "AT_FILEC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_DECIMALC1", "value": "", "displayName": "AT_DECIMALC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_CUSDECIMALC1", "value": "", "displayName": "AT_CUSDECIMALC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_DATEC1", "value": "", "displayName": "AT_DATEC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false }, { "name": "AT_TIMESTAMPC1", "value": "", "displayName": "AT_TIMESTAMPC1", "multivalues": null, "groupName": "Unassigned", "matchingAttribute": false, "multivalue": false } ], "repositoryName": "ALLTYPEC", "relationships": {}, "deleted": false } }]}, "deleted": false } }]}, "deleted": false }], "totalCount": 1 } |