case 1: Request : curl --location 'https://demo.datafabricx.com:8108/multi_search' \
--header 'x-typesense-api-key: ******' \
--header 'Content-Type: application/json' \
--data '{
"searches": [
{
"query_by": "system.lf.file.properties.template",
"per_page": "1",
"exclude_fields": "embedding",
"sort_by": "system.lf.file.properties.file_modified_date:desc",
"highlight_full_fields": "system.lf.file.properties.template",
"collection": "DFXAppv3",
"q": "*",
"facet_by": "system.lf.file.properties.CreatedBy_str,system.lf.file.properties.CreatedDate,system.lf.file.properties.Extension_str,system.lf.file.properties.ModifiedDate,system.lf.file.properties.template.template_fields.Client Id_str,system.lf.file.properties.template.template_fields.Client Name_str,system.lf.file.properties.template.template_name_str",
"max_facet_values": 20,
"page": 1,
"filter_by": "dfx_restricted_document:!= deleted"
}
]
}'
response :{
"results": [
{
"facet_counts": [
{
"counts": [
{
"count": 740495,
"highlighted": "DATAFABRICX\\nmuthu",
"value": "DATAFABRICX\\nmuthu"
}
],
"field_name": "system.lf.file.properties.CreatedBy_str",
"sampled": false,
"stats": {
"total_values": 1
}
},
{
"counts": [
{
"count": 740495,
"highlighted": "1739197170",
"value": "1739197170"
}
],
"field_name": "system.lf.file.properties.CreatedDate",
"sampled": false,
"stats": {
"avg": 1739197170.0,
"max": 1739197170.0,
"min": 1739197170.0,
"sum": 1.28786680839915e+15,
"total_values": 1
}
},
{
"counts": [
{
"count": 148595,
"highlighted": "xlsx",
"value": "xlsx"
},
{
"count": 148300,
"highlighted": "docx",
"value": "docx"
},
{
"count": 148014,
"highlighted": "txt",
"value": "txt"
},
{
"count": 147820,
"highlighted": "pdf",
"value": "pdf"
},
{
"count": 147766,
"highlighted": "pptx",
"value": "pptx"
}
],
"field_name": "system.lf.file.properties.Extension_str",
"sampled": false,
"stats": {
"total_values": 5
}
},
{
"counts": [
{
"count": 740495,
"highlighted": "1747114407",
"value": "1747114407"
}
],
"field_name": "system.lf.file.properties.ModifiedDate",
"sampled": false,
"stats": {
"avg": 1747114407.0,
"max": 1747114407.0,
"min": 1747114407.0,
"sum": 1.293729482811465e+15,
"total_values": 1
}
},
{
"counts": [
{
"count": 148597,
"highlighted": "CL0000111",
"value": "CL0000111"
},
{
"count": 148452,
"highlighted": "CL0000115",
"value": "CL0000115"
},
{
"count": 148358,
"highlighted": "CL0000109",
"value": "CL0000109"
},
{
"count": 147827,
"highlighted": "CL0000114",
"value": "CL0000114"
},
{
"count": 147261,
"highlighted": "CL0000107",
"value": "CL0000107"
}
],
"field_name": "system.lf.file.properties.template.template_fields.Client Id_str",
"sampled": false,
"stats": {
"total_values": 5
}
},
{
"counts": [
{
"count": 122144,
"highlighted": "Kumar Trust",
"value": "Kumar Trust"
},
{
"count": 121604,
"highlighted": "Raleigh Limited",
"value": "Raleigh Limited"
},
{
"count": 121579,
"highlighted": "Helier Investments Limited",
"value": "Helier Investments Limited"
},
{
"count": 120780,
"highlighted": "Walter Trust",
"value": "Walter Trust"
},
{
"count": 108277,
"highlighted": "Baskin Robins Investment Ltd.",
"value": "Baskin Robins Investment Ltd."
},
{
"count": 107778,
"highlighted": "Durban Consultants",
"value": "Durban Consultants"
},
{
"count": 13197,
"highlighted": "k M jb Durban Consultants",
"value": "k M jb Durban Consultants"
},
{
"count": 13136,
"highlighted": " L K Baskin Robins Investment Ltd",
"value": " L K Baskin Robins Investment Ltd"
}
],
"field_name": "system.lf.file.properties.template.template_fields.Client Name_str",
"sampled": false,
"stats": {
"total_values": 8
}
},
{
"counts": [
{
"count": 247077,
"highlighted": "Invoices",
"value": "Invoices"
},
{
"count": 246793,
"highlighted": "Audit",
"value": "Audit"
},
{
"count": 246625,
"highlighted": "Client Document",
"value": "Client Document"
}
],
"field_name": "system.lf.file.properties.template.template_name_str",
"sampled": false,
"stats": {
"total_values": 3
}
}
],
"found": 740495,
"hits": [
{
"document": {
"document_created_by": "DATAFABRICX\\nmuthu",
"document_created_date": "1739197170",
"document_current_version": 0,
"document_id": "840499",
"document_modified_date": "1747114407",
"document_name": "CL840499-23-07-2024-Raleigh Limited",
"document_source": "",
"id": "840499",
"lastupdated_datetime": 1748520991,
"ocr_data": "At most periods of her history India,....",
"ocr_status": "completed",
"system": {
"business": {
"properties": {
"Client Id_str": "CL0000114",
"Client Name_str": "Raleigh Limited",
"DFXAI_str": "Yes",
"Document Date_str": "Jul 23 2024 12:00AM",
"Document Sub Type_str": "A01. Accounting File Note",
"Document Title_str": "CL840499-23-07-2024-Raleigh Limited",
"Document Type_str": "A01. Accounting",
"Repository Type_str": "Client"
}
},
"custom": {},
"lf": {
"file": {
"properties": {
"CreatedBy_str": "DATAFABRICX\\nmuthu",
"CreatedDate": "1739197170",
"DocSize": "731495",
"EntryID_str": "840499",
"EntryName_str": "CL840499-23-07-2024-Raleigh Limited",
"Extension_str": "pdf",
"LFPath_str": "",
"MimeType_str": "application/octet-stream",
"ModifiedDate": "1747114407",
"PageCount": "0",
"ParentId": "116917",
"file_modified_date": "1747114407",
"template": {
"template_fields": {
"Client Id_str": "CL0000114",
"Client Name_str": "Raleigh Limited",
"DFXAI_str": "Yes",
"Document Date_str": "Jul 23 2024 12:00AM",
"Document Sub Type_str": "A01. Accounting File Note",
"Document Title_str": "CL840499-23-07-2024-Raleigh Limited",
"Document Type_str": "A01. Accounting",
"Repository Type_str": "Client"
},
"template_name_str": "Audit"
}
}
}
},
"network": {
"file": {}
}
}
},
"highlight": {},
"highlights": []
}
],
"out_of": 740500,
"page": 1,
"request_params": {
"collection_name": "DFXAppv3",
"first_q": "*",
"per_page": 1,
"q": "*"
},
"search_cutoff": false,
"search_time_ms": 343
}
]
}
case 2: request: curl --location 'https://demo.datafabricx.com:8108/multi_search' \
--header 'x-typesense-api-key: ****' \
--header 'Content-Type: application/json' \
--data '{
"searches": [
{
"query_by": "system.lf.file.properties.template",
"per_page": "1",
"exclude_fields": "embedding",
"sort_by": "system.lf.file.properties.file_modified_date:desc",
"highlight_full_fields": "system.lf.file.properties.template",
"collection": "DFXAppv3",
"q": "Baskin Robins Investment Ltd.",
"facet_by": "system.lf.file.properties.CreatedBy_str,system.lf.file.properties.CreatedDate,system.lf.file.properties.Extension_str,system.lf.file.properties.ModifiedDate,system.lf.file.properties.template.template_fields.Client Id_str,system.lf.file.properties.template.template_fields.Client Name_str,system.lf.file.properties.template.template_name_str",
"max_facet_values": 20,
"page": 1,
"filter_by": "dfx_restricted_document:!= deleted"
}
]
}'
Response:{
"results": [
{
"facet_counts": [
{
"counts": [
{
"count": 123413,
"highlighted": "DATAFABRICX\\nmuthu",
"value": "DATAFABRICX\\nmuthu"
}
],
"field_name": "system.lf.file.properties.CreatedBy_str",
"sampled": false,
"stats": {
"total_values": 1
}
},
{
"counts": [
{
"count": 123413,
"highlighted": "1739197170",
"value": "1739197170"
}
],
"field_name": "system.lf.file.properties.CreatedDate",
"sampled": false,
"stats": {
"avg": 1739197170.0,
"max": 1739197170.0,
"min": 1739197170.0,
"sum": 214639540341210.0,
"total_values": 1
}
},
{
"counts": [
{
"count": 24961,
"highlighted": "xlsx",
"value": "xlsx"
},
{
"count": 24715,
"highlighted": "docx",
"value": "docx"
},
{
"count": 24596,
"highlighted": "txt",
"value": "txt"
},
{
"count": 24595,
"highlighted": "pdf",
"value": "pdf"
},
{
"count": 24546,
"highlighted": "pptx",
"value": "pptx"
}
],
"field_name": "system.lf.file.properties.Extension_str",
"sampled": false,
"stats": {
"total_values": 5
}
},
{
"counts": [
{
"count": 123413,
"highlighted": "1747114407",
"value": "1747114407"
}
],
"field_name": "system.lf.file.properties.ModifiedDate",
"sampled": false,
"stats": {
"avg": 1747114407.0,
"max": 1747114407.0,
"min": 1747114407.0,
"sum": 215616630311091.0,
"total_values": 1
}
},
{
"counts": [
{
"count": 24947,
"highlighted": "CL0000111",
"value": "CL0000111"
},
{
"count": 24695,
"highlighted": "CL0000114",
"value": "CL0000114"
},
{
"count": 24625,
"highlighted": "CL0000115",
"value": "CL0000115"
},
{
"count": 24613,
"highlighted": "CL0000107",
"value": "CL0000107"
},
{
"count": 24533,
"highlighted": "CL0000109",
"value": "CL0000109"
}
],
"field_name": "system.lf.file.properties.template.template_fields.Client Id_str",
"sampled": false,
"stats": {
"total_values": 5
}
},
{
"counts": [
{
"count": 108277,
"highlighted": "Baskin Robins Investment Ltd.",
"value": "Baskin Robins Investment Ltd."
},
{
"count": 13136,
"highlighted": " L K Baskin Robins Investment Ltd",
"value": " L K Baskin Robins Investment Ltd"
}
],
"field_name": "system.lf.file.properties.template.template_fields.Client Name_str",
"sampled": false,
"stats": {
"total_values": 2
}
},
{
"counts": [
{
"count": 41239,
"highlighted": "Audit",
"value": "Audit"
},
{
"count": 41089,
"highlighted": "Invoices",
"value": "Invoices"
},
{
"count": 41085,
"highlighted": "Client Document",
"value": "Client Document"
}
],
"field_name": "system.lf.file.properties.template.template_name_str",
"sampled": false,
"stats": {
"total_values": 3
}
}
],
"found": 123413,
"hits": [
{
"document": {
"document_created_by": "DATAFABRICX\\nmuthu",
"document_created_date": "1739197170",
"document_current_version": 0,
"document_id": "840494",
"document_modified_date": "1747114407",
"document_name": "CL840494-23-07-2024-Baskin Robins Investment Ltd.",
"document_source": "",
"id": "840494",
"lastupdated_datetime": 1748520991,
"ocr_data": "At most periods of her history India, ",
"ocr_status": "completed",
"system": {
"business": {
"properties": {
"Client Id_str": "CL0000111",
"Client Name_str": "Baskin Robins Investment Ltd.",
"DFXAI_str": "Yes",
"Document Date_str": "Jul 23 2024 12:00AM",
"Document Sub Type_str": "A01. Accounting File Note",
"Document Title_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.",
"Document Type_str": "A01. Accounting",
"Repository Type_str": "Client"
}
},
"custom": {},
"lf": {
"file": {
"properties": {
"CreatedBy_str": "DATAFABRICX\\nmuthu",
"CreatedDate": "1739197170",
"DocSize": "731495",
"EntryID_str": "840494",
"EntryName_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.",
"Extension_str": "pptx",
"LFPath_str": "",
"MimeType_str": "application/octet-stream",
"ModifiedDate": "1747114407",
"PageCount": "0",
"ParentId": "116917",
"file_modified_date": "1747114407",
"template": {
"template_fields": {
"Client Id_str": "CL0000111",
"Client Name_str": "Baskin Robins Investment Ltd.",
"DFXAI_str": "Yes",
"Document Date_str": "Jul 23 2024 12:00AM",
"Document Sub Type_str": "A01. Accounting File Note",
"Document Title_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.",
"Document Type_str": "A01. Accounting",
"Repository Type_str": "Client"
},
"template_name_str": "Client Document"
}
}
}
},
"network": {
"file": {}
}
}
},
"highlight": {
"system": {
"lf": {
"file": {
"properties": {
"template": {
"template_fields": {
"Client Id_str": {
"matched_tokens": [],
"snippet": "CL0000111",
"value": "CL0000111"
},
"Client Name_str": {
"matched_tokens": [
"Baskin",
"Robins",
"Investment",
"Ltd"
],
"snippet": "Baskin Robins Investment Ltd.",
"value": "Baskin Robins Investment Ltd."
},
"DFXAI_str": {
"matched_tokens": [],
"snippet": "Yes",
"value": "Yes"
},
"Document Date_str": {
"matched_tokens": [],
"snippet": "Jul 23 2024 12:00AM",
"value": "Jul 23 2024 12:00AM"
},
"Document Sub Type_str": {
"matched_tokens": [],
"snippet": "A01. Accounting File Note",
"value": "A01. Accounting File Note"
},
"Document Title_str": {
"matched_tokens": [
"Robins",
"Investment",
"Ltd"
],
"snippet": "CL840494-23-07-2024-Baskin Robins Investment Ltd.",
"value": "CL840494-23-07-2024-Baskin Robins Investment Ltd."
},
"Document Type_str": {
"matched_tokens": [],
"snippet": "A01. Accounting",
"value": "A01. Accounting"
},
"Repository Type_str": {
"matched_tokens": [],
"snippet": "Client",
"value": "Client"
}
},
"template_name_str": {
"matched_tokens": [],
"snippet": "Client Document",
"value": "Client Document"
}
}
}
}
}
}
},
"highlights": [],
"text_match": 2314894167593451522,
"text_match_info": {
"best_field_score": "4419510927616",
"best_field_weight": 0,
"fields_matched": 2,
"num_tokens_dropped": 0,
"score": "2314894167593451522",
"tokens_matched": 4,
"typo_prefix_score": 0
}
}
],
"out_of": 740500,
"page": 1,
"request_params": {
"collection_name": "DFXAppv3",
"first_q": "Baskin Robins Investment Ltd.",
"per_page": 1,
"q": "Baskin Robins Investment Ltd."
},
"search_cutoff": false,
"search_time_ms": 531
}
]
}