File Search
GET
{{api_url}}/data_bridge/files/search?limit&limit_start&sort&search=They query parameter 'search' is a JSON encoded array that allows advanced filtering of data bridge files.
group_operator: and, or
search_type: single, group
condition_type: is_set, is_not_set, eq, neq, gt, gteq, lt, lteq, contains, dn_contain, starts_with, ends_with, dn_start_with, dn_end_with
Examples are below
[
{
"search_type": "group",
"group_operator": "and",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "eq",
"data_name_value": "order_source",
"data_value_condition_type": "starts_with",
"data_value_value": "Wal"
},
{
"search_type": "single",
"data_name_condition_type": "eq",
"data_name_value": "external_order_num",
"data_value_condition_type": "contains",
"data_value_value": "048073"
}
]
}
]
[
{
"search_type": "group",
"group_operator": "and",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "top_level_sku"
},
{
"search_type": "single",
"data_name_condition_type": "eq",
"data_name_value": "price",
"data_value_condition_type": "lt",
"data_value_value": "100"
}
]
},
{
"search_type": "group",
"group_operator": "and",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "top_level_sku"
},
{
"search_type": "single",
"data_name_condition_type": "eq",
"data_name_value": "price",
"data_value_condition_type": "lt",
"data_value_value": "100zz.00"
}
]
},
{
"search_type": "single",
"data_name_condition_type": "eq",
"data_name_value": "price",
"data_value_condition_type": "lt",
"data_value_value": "22222"
},
{
"search_type": "group",
"group_operator": "and",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_sku_search"
},
{
"search_type": "group",
"group_operator": "or",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level1_child_1"
},
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level1_child_2"
}
]
},
{
"search_type": "group",
"group_operator": "or",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level2_child_1"
},
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level2_child_2"
}
]
}
]
},
{
"search_type": "group",
"group_operator": "and",
"searches": [
{
"search_type": "group",
"group_operator": "or",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level3_child_1"
},
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level3_child_2"
}
]
},
{
"search_type": "group",
"group_operator": "or",
"searches": [
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level4_child_1"
},
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_level4_child_2"
}
]
},
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_sku_search"
}
]
}
]
[
{
"search_type": "single",
"data_name_condition_type": "starts_with",
"data_name_value": "sku",
"data_value_condition_type": "eq",
"data_value_value": "second_sku_search"
}
]
Authorization
Bearer token, sent in the Authorization header. Inherited from the collection.
Query Parameters
| Key | Value | Description |
|---|---|---|
limit | If this is set, then only this number of results will be returned | |
limit_start | If 100 results are returned and this is set to 25, the first 25 results will be omitted | |
sort | Default is data_bridge_data_id ASC | |
search | This is a JSON formatted search. |
Example Request
curl --location --request GET '{{api_url}}/data_bridge/files/search?limit&limit_start&sort&search=' \
--header 'Authorization: Bearer {{auth_token}}'Example Responses
File Search - Simple Group
Request
curl --location --request GET '{{api_url}}/data_bridge/files/search?limit&limit_start&sort&search=[{"search_type":"group","group_operator":"and","searches":[{"search_type":"single","data_name_condition_type":"eq","data_name_value":"order_source","data_value_condition_type":"starts_with","data_value_value":"Wal"},{"search_type":"single","data_name_condition_type":"eq","data_name_value":"external_order_num","data_value_condition_type":"contains","data_value_value":"048073"}]}]' \
--header 'Authorization: Bearer {{auth_token}}'Response 200 OK
[
{
"data_bridge_file_id": "109",
"data_bridge_file_siteareaid": "16",
"date_created": "2022-05-25 15:11:17",
"file_content_base64": "ewogICJzaG9wX29yZGVyaWQiOiAiMTAxNzY5IiwKICAic2hvcF9vcmRlcl9zaXRlYXJlYWlkIjogIjE2IiwKICAic2hvcF9vcmRlcl91aWQiOiAiMCIsCiAgIm9yZGVyX2tleSI6ICJOV0xkMHE0TWFodGwzU0ZOdjNYUnUxQnlmeHc2OGdLQWlSUXVvb1NNdGYyRlpOWXdkS0l2NHhKMFdFSFNoZ2k0MkdVV2pmcVhQQ3k1REQ3TEZWMjE4Z21UU05QUktEMnNXVUFyUUw1NXMya1pZZXVmZFE2anA2YjRYOVBuQ09Ed0V1eEtaWjh2cW1jZmNUc1FQZkN3aWk5Q2FpcGFQaEdnY2JES0lsTHNtSSIsCiAgIm9yZGVyX3NvdXJjZSI6ICJXYWxtYXJ0IiwKICAib3JkZXJfZGF0ZSI6ICIyMDE4LTA1LTE2IDE3OjU2OjA2IiwKICAiZW1haWwiOiAiIiwKICAicGhvbmUiOiAiIiwKICAic2hpcF9maXJzdF9uYW1lIjogIlNjb3R0IiwKICAic2hpcF9sYXN0X25hbWUiOiAiU3dvYm9kYSIsCiAgInNoaXBfY29tcGFueSI6ICIiLAogICJzaGlwX3N0cmVldDEiOiAiMjVXNTYwIEdlbmV2YSBSZC4gU3VpdGUgMSIsCiAgInNoaXBfc3RyZWV0MiI6ICIiLAogICJzaGlwX2NpdHkiOiAiQ2Fyb2wgU3RyZWFtIiwKICAic2hpcF9zdGF0ZSI6ICJJTCIsCiAgInNoaXBfcmVnaW9uIjogIiIsCiAgInNoaXBfemlwIjogIjYwMTg4IiwKICAic2hpcF9jb3VudHJ5IjogIlVTIiwKICAiYmlsbF9maXJzdF9uYW1lIjogIlNjb3R0IiwKICAiYmlsbF9sYXN0X25hbWUiOiAiU3dvYm9kYSIsCiAgImJpbGxfY29tcGFueSI6ICIiLAogICJiaWxsX3N0cmVldDEiOiAiMjVXNTYwIEdlbmV2YSBSZC4gU3VpdGUgMSIsCiAgImJpbGxfc3RyZWV0MiI6ICIiLAogICJiaWxsX2NpdHkiOiAiQ2Fyb2wgU3RyZWFtIiwKICAiYmlsbF9zdGF0ZSI6ICJJTCIsCiAgImJpbGxfcmVnaW9uIjogIiIsCiAgImJpbGxfemlwIjogIjYwMTg4IiwKICAiYmlsbF9jb3VudHJ5IjogIlVTIiwKICAic2hpcF9wcmljZSI6ICIyLjk1IiwKICAic2hpcF9oYW5kbGluZyI6ICIwLjAwIiwKICAic2hpcF9pZGVudGlmaWVyIjogIiIsCiAgInNoaXBfdHlwZSI6ICIwIiwKICAic2hpcF9sYWJlbCI6ICIiLAogICJzaGlwX3dlaWdodF90b3RhbCI6ICIwLjAwIiwKICAic2hpcF9zcGVlZCI6ICIxIiwKICAiaXRlbV90b3RhbCI6ICIxNC45OSIsCiAgImRpc2NvdW50X3RvdGFsIjogIjAuMDAiLAogICJzaGlwX3RvdGFsIjogIjIuOTUiLAogICJ0YXhfdG90YWwiOiAiMC4wMCIsCiAgIm9yZGVyX3RvdGFsIjogIjE3Ljk0IiwKICAiY2NfdHlwZSI6ICIiLAogICJjY19udW0iOiBudWxsLAogICJjY19leHBfbW9uIjogIiIsCiAgImNjX2V4cF95ZWFyIjogIiIsCiAgImNjX2xhc3RfZm91ciI6ICIiLAogICJpc19wcm9jZXNzZWQiOiAiMCIsCiAgImV4dGVybmFsX29yZGVyX251bSI6ICIxMDAwLTA0ODA3My02NjIzNjAiLAogICJleHRlcm5hbF9vcmRlcl9zb3VyY2UiOiBudWxsLAogICJmdWxseV9zaGlwcGVkIjogIjEiLAogICJpc19hbWF6b25fcGF5bWVudCI6ICIwIiwKICAiaXNfcGF5cGFsX3BheW1lbnQiOiAiMCIsCiAgImlzX2NhbmNlbGVkIjogIjAiLAogICJxdWlja2Jvb2tzX3VzZXJfbGlzdGlkIjogbnVsbCwKICAiaXNfc2F2ZWRfaW5fcXVpY2tib29rcyI6ICIwIiwKICAiaXNfcXVldWVkX2Zvcl9xdWlja2Jvb2tzX3NhdmUiOiAiMCIsCiAgInF1aWNrYm9va3NfaW52b2ljZV9saXN0aWQiOiBudWxsLAogICJvcmRlcl90YWciOiBudWxsLAogICJpbl9wcm9jZXNzIjogIjAiLAogICJwcm9jZXNzZWRfYnkiOiBudWxsLAogICJwcm9jZXNzZWRfZGF0ZSI6IG51bGwsCiAgIm9yZGVyX3RhayI6IG51bGwsCiAgIm9yZGVyX3JlZmVyZXIiOiAiIiwKICAiZGF0ZV9jcmVhdGVkIjogIjIwMTgtMDYtMDkgMTM6NDM6MDQiLAogICJhbWF6b25fcGF5bWVudF9vcmRlcl9pZCI6IG51bGwsCiAgInBvX251bWJlciI6IG51bGwsCiAgInNlc3Npb25faWQiOiBudWxsLAogICJ1c2VyX3VucV9pZGVudGlmaWVyIjogbnVsbCwKICAibWVyY2hhbnRfdHJhbnNfaWQiOiBudWxsLAogICJtZXJjaGFudF9jdXN0b21lcl9wcm9maWxlX2lkIjogbnVsbCwKICAibWVyY2hhbnRfY3VzdG9tZXJfcGF5bWVudF9wcm9maWxlX2lkIjogbnVsbCwKICAiaGFzX291dHN0YW5kaW5nX3ByZV9vcmRlcl9pdGVtcyI6ICIwIiwKICAicHJlX29yZGVyX2NvbXBsZXRlZF9kYXRlIjogbnVsbCwKICAicHJlX29yZGVyX3JlbGVhc2VfZGF0ZSI6IG51bGwsCiAgIm9yZGVyX2N1cnJlbmN5IjogInVzZCIsCiAgIm9yZGVyX2N1cnJlbmN5X3N5bWJvbCI6ICIkIiwKICAibGFzdF9tb2RpZmllZCI6ICIyMDE4LTA2LTEwIDE0OjI5OjM3IiwKICAiaXNfc2VsbGVyX2Z1bGZpbGxlZF9wcmltZSI6ICIwIiwKICAiZ2lmdF9jYXJkX3RvdGFsIjogIjAuMDAiLAogICJxYm9fb3JkZXJfbmVlZHNfcHVsbGluZyI6ICIxIiwKICAicWJvX3NhbGVzX3JlY2VpcHRfaWQiOiBudWxsLAogICJvcmRlcl9mdWxseV9zYXZlZCI6ICIxIiwKICAib3V0c3RhbmRpbmdfYW1hem9uX2N1c3RvbV9wcm9kIjogIjAiLAogICJuZWVkc190b19ydW5fZHJvcF9zaGlwcGVyX3Byb2Nlc3NpbmciOiAiMSIsCiAgImlzX3dhbG1hcnRfZHN2X3NoaXBfdG9fc3RvcmUiOiAiMCIsCiAgImFkZGl0aW9uYWxfY3VzdG9tZXJfb3JkZXJfaWQiOiBudWxsLAogICJwYXltZW50X3R5cGUiOiBudWxsLAogICJwYXltZW50X25vdGUiOiBudWxsLAogICJtZXJjaGFudF9uYW1lIjogbnVsbCwKICAiaXNfY2hhbm5lbF9hZHZpc29yX29yZGVyIjogIjAiLAogICJjaGFubmVsX2Fkdmlzb3JfcHJvZmlsZV9pZCI6IG51bGwsCiAgImV4dGVybmFsX2V4dGVybmFsX29yZGVyX251bSI6IG51bGwsCiAgImV4dGVybmFsX2V4dGVybmFsX29yZGVyX3NvdXJjZSI6IG51bGwsCiAgImVzdGltYXRlZF9zaGlwX2RhdGUiOiBudWxsLAogICJlc3RpbWF0ZWRfZGVsaXZlcnlfZGF0ZSI6IG51bGwsCiAgIm9yZGVyX2l0ZW1zIjogWwogICAgewogICAgICAic2hvcF9vcmRlcl9pdGVtaWQiOiAiMTExMCIsCiAgICAgICJzaG9wX29yZGVyX2l0ZW1fb3JkZXJpZCI6ICIxMDE3NjkiLAogICAgICAic2hvcF9vcmRlcl9pdGVtX3Byb2R1Y3RpZCI6ICIxMTYiLAogICAgICAic2hvcF9vcmRlcl9pdGVtX3NrdWlkIjogbnVsbCwKICAgICAgInNob3Bfb3JkZXJfaXRlbV9jbGllbnRpZCI6IG51bGwsCiAgICAgICJwcm9kdWN0X25hbWUiOiAiVHdpbmluZ3MgRWFybCBHcmV5IFRlYSAyNCBjdCIsCiAgICAgICJwcm9kdWN0X2Rlc2NyaXB0aW9uIjogIiIsCiAgICAgICJza3UiOiAiMDg3NTYtMSIsCiAgICAgICJza3VfZGVzY3JpcHRpb24iOiAiIiwKICAgICAgIm91dF9vZl9zdG9ja19tZXNzYWdlIjogbnVsbCwKICAgICAgInByaWNlIjogIjE0Ljk5IiwKICAgICAgInF1YW50aXR5IjogIjEiLAogICAgICAic2hpcF93ZWlnaHQiOiAiMC4wMCIsCiAgICAgICJzaGlwX3dlaWdodF90b3RhbCI6ICIwLjAwIiwKICAgICAgInNoaXBfdG90YWwiOiAiMi45NSIsCiAgICAgICJ0YXhfdG90YWwiOiAiMC4wMCIsCiAgICAgICJkaXNjb3VudF90b3RhbCI6ICIwLjAwIiwKICAgICAgIml0ZW1fdG90YWwiOiAiMTQuOTkiLAogICAgICAidGF4X25hbWUiOiAiIiwKICAgICAgInRheF9yYXRlIjogIjAuMDAwIiwKICAgICAgImV4dGVybmFsX2l0ZW1pZCI6ICIxNTUyMzkiLAogICAgICAicXVpY2tib29rc19saXN0aWQiOiBudWxsLAogICAgICAiaXNfcXVldWVkX2Zvcl9xdWlja2Jvb2tzX3NhdmUiOiAiMCIsCiAgICAgICJzaGlwX2xlbmd0aF9pbmNoZXMiOiAiMC4wMCIsCiAgICAgICJzaGlwX3dpZHRoX2luY2hlcyI6ICIwLjAwIiwKICAgICAgInNoaXBfaGVpZ2h0X2luY2hlcyI6ICIwLjAwIiwKICAgICAgIml0ZW1fY29zdCI6IG51bGwsCiAgICAgICJwcmVfb3JkZXJfYW1vdW50X3JlbWFpbmluZyI6ICIwLjAwIiwKICAgICAgInByZV9vcmRlcl9jb21wbGV0ZWRfZGF0ZSI6IG51bGwsCiAgICAgICJwcmVfb3JkZXJfcmVsZWFzZV9kYXRlIjogbnVsbCwKICAgICAgImFtYXpvbl9jdXN0b21fcHJvZCI6ICIwIiwKICAgICAgImFtYXpvbl9jdXN0b21fcHJvZF9wcm9jZXNzZWQiOiAiMCIsCiAgICAgICJpc19hbWF6b25fZmJhIjogMCwKICAgICAgIml0ZW1fbm90ZSI6IG51bGwsCiAgICAgICJpdGVtX3VwYyI6IG51bGwsCiAgICAgICJpdGVtX2lzYm4iOiBudWxsLAogICAgICAiaXRlbV9hc2luIjogbnVsbCwKICAgICAgIml0ZW1fZ3RpbiI6IG51bGwsCiAgICAgICJpdGVtX2VhbiI6IG51bGwsCiAgICAgICJpdGVtX2FkZGl0aW9uYWxfaWQiOiBudWxsLAogICAgICAib3B0aW9uX2luZm8iOiBudWxsLAogICAgICAiaW5wdXRfb3B0aW9uX2luZm8iOiBudWxsLAogICAgICAid2FyZWhvdXNlIjogWwogICAgICAgIHsKICAgICAgICAgICJzaG9wX29yZGVyX2l0ZW1fd2FyZWhvdXNlIjogIjY5OCIsCiAgICAgICAgICAic29pd19pdGVtaWQiOiAiMTExMCIsCiAgICAgICAgICAid2FyZWhvdXNlX25hbWUiOiAiU2Vjb25kYXJ5IFdhcmVob3VzZSIsCiAgICAgICAgICAid2FyZWhvdXNlX2lkZW50aWZpZXIiOiAic2Vjb25kYXJ5IiwKICAgICAgICAgICJxdWFudGl0eSI6ICIxIiwKICAgICAgICAgICJiaW5fbG9jYXRpb24iOiBudWxsLAogICAgICAgICAgImRyb3Bfc2hpcHBlcl9pZCI6ICIxIgogICAgICAgIH0KICAgICAgXSwKICAgICAgInF1YW50aXR5X3NoaXBwZWQiOiAiMSIsCiAgICAgICJxdWFudGl0eV90b19zaGlwIjogMCwKICAgICAgInF1YW50aXR5X3JldHVybmVkIjogMCwKICAgICAgInF1YW50aXR5X3RvX3JldHVybiI6ICIxIiwKICAgICAgImN1c3RvbWl6YXRpb25faW5mbyI6IG51bGwsCiAgICAgICJmcmllbmRseV91cmwiOiAiIiwKICAgICAgImltYWdlcyI6IG51bGwKICAgIH0KICBdLAogICJ0cmFja2luZ19udW1iZXJzIjogWwogICAgewogICAgICAic2hvcF9vcmRlcl9zaGlwX3RyYWNraW5naWQiOiAiMTA4NiIsCiAgICAgICJzb3N0X29yZGVyaWQiOiAiMTAxNzY5IiwKICAgICAgInRyYWNraW5nX251bSI6ICIxMjM0NTY3ODkwIiwKICAgICAgImRhdGVfY3JlYXRlZCI6ICIyMDE4LTA2LTEwIDE0OjI5OjM3IiwKICAgICAgImVtYWlsX3NlbnQiOiBudWxsLAogICAgICAiZW1haWxfc2VudF9kYXRlIjogbnVsbCwKICAgICAgImJhbGFuY2VtYXh4X3RyYWNraW5nX3NlbnQiOiAiMCIsCiAgICAgICJiYWxhbmNlbWF4eF90cmFja2luZ19zZW50X2RhdGUiOiBudWxsLAogICAgICAibGFiZWxfY29zdCI6IG51bGwsCiAgICAgICJsYWJlbF9pbWciOiBudWxsLAogICAgICAib3ZlcmxvYWRfc2hpcF93ZWlnaHRfdG90YWwiOiBudWxsLAogICAgICAibGVuZ3RoX2luY2hlcyI6ICIwIiwKICAgICAgIndpZHRoX2luY2hlcyI6ICIwIiwKICAgICAgImhlaWdodF9pbmNoZXMiOiAiMCIsCiAgICAgICJjYXJyaWVyX25hbWUiOiAiRmVkRXgiLAogICAgICAiY2Fycmllcl9tZXRob2QiOiAiTmV4dERheSIsCiAgICAgICJpc19hbWF6b25fZmJhIjogIjAiLAogICAgICAiaXNfcmVzaWRlbnRpYWwiOiAiMCIsCiAgICAgICJ1c2VfbmVnb3RpYXRlZCI6ICIwIiwKICAgICAgIndvcmxkc2hpcF9kb3dubG9hZGVkIjogIjAiLAogICAgICAic3RhbmRhcmRfZG93bmxvYWRlZCI6ICIwIiwKICAgICAgInNpZ25hdHVyZV90eXBlIjogbnVsbCwKICAgICAgImlzX2RlbGl2ZXJlZCI6ICIwIiwKICAgICAgImVzdGltYXRlZF9kZWxpdmVyeSI6IG51bGwsCiAgICAgICJkZWxpdmVyeV90aW1lIjogbnVsbCwKICAgICAgInRyYWNraW5nX2FjdGl2aXR5X3N1bW1hcnkiOiBudWxsLAogICAgICAiaXNfdXBzIjogIjAiLAogICAgICAiaXNfZmVkZXgiOiAiMCIsCiAgICAgICJpc19zdGFtcHMiOiAiMCIsCiAgICAgICJzaG91bGRfc3RpbGxfY2hlY2tfdHJhY2tpbmciOiAiMSIsCiAgICAgICJsYXN0X3RyYWNraW5nX2FjdGl2aXR5X2NoZWNrIjogIjIwMTgtMDYtMTAgMTQ6Mjk6MzciLAogICAgICAiY2Fycmllcl93aWxsX3BpY2tfdXAiOiAiMCIsCiAgICAgICJkZWNsYXJlZF92YWx1ZSI6IG51bGwsCiAgICAgICJleHRlcm5hbF9zaGlwbWVudF9pZCI6IG51bGwsCiAgICAgICJpc193YWxtYXJ0X2Rzdl9zaGlwX3RvX3N0b3JlIjogIjAiLAogICAgICAid2FsbWFydF9hc24iOiBudWxsLAogICAgICAidXNwc196b25lIjogbnVsbCwKICAgICAgInBhY2thZ2Vfc2l6ZV9uYW1lIjogbnVsbCwKICAgICAgInBhY2tpbmdfc2xpcF9pZCI6IG51bGwsCiAgICAgICJvcmRlcl9zb3VyY2UiOiAiR3JvdXBvbiIsCiAgICAgICJleHRlcm5hbF9vcmRlcl9udW0iOiAiMTAwMC0wNDgwNzMtNjYyMzYwIiwKICAgICAgInNob3Bfb3JkZXJfc2l0ZWFyZWFpZCI6ICIxNiIsCiAgICAgICJwYWNrYWdlX2l0ZW1zIjogWwogICAgICAgIHsKICAgICAgICAgICJzaG9wX29yZGVyX3NoaXBfdHJhY2tpbmdfaXRlbWlkIjogIjExNjgiLAogICAgICAgICAgInNvc3RpX3RyYWNraW5naWQiOiAiMTA4NiIsCiAgICAgICAgICAic29zdGlfaXRlbWlkIjogIjExMTAiLAogICAgICAgICAgInF1YW50aXR5X3NoaXBwZWQiOiAiMSIsCiAgICAgICAgICAicHJvZHVjdF9uYW1lIjogIlR3aW5pbmdzIEVhcmwgR3JleSBUZWEgMjQgY3QiLAogICAgICAgICAgInNoaXBfd2VpZ2h0IjogIjAuMDAiLAogICAgICAgICAgImV4dGVybmFsX2l0ZW1pZCI6ICIxNTUyMzkiLAogICAgICAgICAgInNrdSI6ICIwODc1Ni0xIiwKICAgICAgICAgICJzaGlwX2xlbmd0aF9pbmNoZXMiOiAiMC4wMCIsCiAgICAgICAgICAic2hpcF93aWR0aF9pbmNoZXMiOiAiMC4wMCIsCiAgICAgICAgICAic2hpcF9oZWlnaHRfaW5jaGVzIjogIjAuMDAiLAogICAgICAgICAgInF1YW50aXR5IjogIjEiLAogICAgICAgICAgIml0ZW1fdXBjIjogbnVsbCwKICAgICAgICAgICJpdGVtX2lzYm4iOiBudWxsLAogICAgICAgICAgIml0ZW1fYXNpbiI6IG51bGwsCiAgICAgICAgICAiaXRlbV9ndGluIjogbnVsbCwKICAgICAgICAgICJpdGVtX2VhbiI6IG51bGwsCiAgICAgICAgICAiaXRlbV9hZGRpdGlvbmFsX2lkIjogbnVsbCwKICAgICAgICAgICJza3VfY3VzdG9tX2RhdGEiOiBudWxsCiAgICAgICAgfQogICAgICBdLAogICAgICAidHJhY2tpbmdfYWN0aXZpdHkiOiBudWxsCiAgICB9CiAgXSwKICAiY291cG9ucyI6IG51bGwsCiAgInJtYV9udW1iZXJzIjogWzEsMiwzXSwKICAibm90ZXMiOiBudWxsLAogICJlbWFpbF9kcm9wX3NoaXBwZXJfcG9zIjogbnVsbCwKICAidGFza3MiOiBudWxsLAogICJhZGRpdGlvbmFsX2luZm8iOiBudWxsCn0=",
"file_type": "json",
"file_name": null,
"file_content_converted_to_json": "{\n \"shop_orderid\": \"101769\",\n \"shop_order_siteareaid\": \"16\",\n \"shop_order_uid\": \"0\",\n \"order_key\": \"NWLd0q4Mahtl3SFNv3XRu1Byfxw68gKAiRQuooSMtf2FZNYwdKIv4xJ0WEHShgi42GUWjfqXPCy5DD7LFV218gmTSNPRKD2sWUArQL55s2kZYeufdQ6jp6b4X9PnCODwEuxKZZ8vqmcfcTsQPfCwii9CaipaPhGgcbDKIlLsmI\",\n \"order_source\": \"Walmart\",\n \"order_date\": \"2018-05-16 17:56:06\",\n \"email\": \"\",\n \"phone\": \"\",\n \"ship_first_name\": \"Scott\",\n \"ship_last_name\": \"Swoboda\",\n \"ship_company\": \"\",\n \"ship_street1\": \"25W560 Geneva Rd. Suite 1\",\n \"ship_street2\": \"\",\n \"ship_city\": \"Carol Stream\",\n \"ship_state\": \"IL\",\n \"ship_region\": \"\",\n \"ship_zip\": \"60188\",\n \"ship_country\": \"US\",\n \"bill_first_name\": \"Scott\",\n \"bill_last_name\": \"Swoboda\",\n \"bill_company\": \"\",\n \"bill_street1\": \"25W560 Geneva Rd. Suite 1\",\n \"bill_street2\": \"\",\n \"bill_city\": \"Carol Stream\",\n \"bill_state\": \"IL\",\n \"bill_region\": \"\",\n \"bill_zip\": \"60188\",\n \"bill_country\": \"US\",\n \"ship_price\": \"2.95\",\n \"ship_handling\": \"0.00\",\n \"ship_identifier\": \"\",\n \"ship_type\": \"0\",\n \"ship_label\": \"\",\n \"ship_weight_total\": \"0.00\",\n \"ship_speed\": \"1\",\n \"item_total\": \"14.99\",\n \"discount_total\": \"0.00\",\n \"ship_total\": \"2.95\",\n \"tax_total\": \"0.00\",\n \"order_total\": \"17.94\",\n \"cc_type\": \"\",\n \"cc_num\": null,\n \"cc_exp_mon\": \"\",\n \"cc_exp_year\": \"\",\n \"cc_last_four\": \"\",\n \"is_processed\": \"0\",\n \"external_order_num\": \"1000-048073-662360\",\n \"external_order_source\": null,\n \"fully_shipped\": \"1\",\n \"is_amazon_payment\": \"0\",\n \"is_paypal_payment\": \"0\",\n \"is_canceled\": \"0\",\n \"quickbooks_user_listid\": null,\n \"is_saved_in_quickbooks\": \"0\",\n \"is_queued_for_quickbooks_save\": \"0\",\n \"quickbooks_invoice_listid\": null,\n \"order_tag\": null,\n \"in_process\": \"0\",\n \"processed_by\": null,\n \"processed_date\": null,\n \"order_tak\": null,\n \"order_referer\": \"\",\n \"date_created\": \"2018-06-09 13:43:04\",\n \"amazon_payment_order_id\": null,\n \"po_number\": null,\n \"session_id\": null,\n \"user_unq_identifier\": null,\n \"merchant_trans_id\": null,\n \"merchant_customer_profile_id\": null,\n \"merchant_customer_payment_profile_id\": null,\n \"has_outstanding_pre_order_items\": \"0\",\n \"pre_order_completed_date\": null,\n \"pre_order_release_date\": null,\n \"order_currency\": \"usd\",\n \"order_currency_symbol\": \"$\",\n \"last_modified\": \"2018-06-10 14:29:37\",\n \"is_seller_fulfilled_prime\": \"0\",\n \"gift_card_total\": \"0.00\",\n \"qbo_order_needs_pulling\": \"1\",\n \"qbo_sales_receipt_id\": null,\n \"order_fully_saved\": \"1\",\n \"outstanding_amazon_custom_prod\": \"0\",\n \"needs_to_run_drop_shipper_processing\": \"1\",\n \"is_walmart_dsv_ship_to_store\": \"0\",\n \"additional_customer_order_id\": null,\n \"payment_type\": null,\n \"payment_note\": null,\n \"merchant_name\": null,\n \"is_channel_advisor_order\": \"0\",\n \"channel_advisor_profile_id\": null,\n \"external_external_order_num\": null,\n \"external_external_order_source\": null,\n \"estimated_ship_date\": null,\n \"estimated_delivery_date\": null,\n \"order_items\": [\n {\n \"shop_order_itemid\": \"1110\",\n \"shop_order_item_orderid\": \"101769\",\n \"shop_order_item_productid\": \"116\",\n \"shop_order_item_skuid\": null,\n \"shop_order_item_clientid\": null,\n \"product_name\": \"Twinings Earl Grey Tea 24 ct\",\n \"product_description\": \"\",\n \"sku\": \"08756-1\",\n \"sku_description\": \"\",\n \"out_of_stock_message\": null,\n \"price\": \"14.99\",\n \"quantity\": \"1\",\n \"ship_weight\": \"0.00\",\n \"ship_weight_total\": \"0.00\",\n \"ship_total\": \"2.95\",\n \"tax_total\": \"0.00\",\n \"discount_total\": \"0.00\",\n \"item_total\": \"14.99\",\n \"tax_name\": \"\",\n \"tax_rate\": \"0.000\",\n \"external_itemid\": \"155239\",\n \"quickbooks_listid\": null,\n \"is_queued_for_quickbooks_save\": \"0\",\n \"ship_length_inches\": \"0.00\",\n \"ship_width_inches\": \"0.00\",\n \"ship_height_inches\": \"0.00\",\n \"item_cost\": null,\n \"pre_order_amount_remaining\": \"0.00\",\n \"pre_order_completed_date\": null,\n \"pre_order_release_date\": null,\n \"amazon_custom_prod\": \"0\",\n \"amazon_custom_prod_processed\": \"0\",\n \"is_amazon_fba\": 0,\n \"item_note\": null,\n \"item_upc\": null,\n \"item_isbn\": null,\n \"item_asin\": null,\n \"item_gtin\": null,\n \"item_ean\": null,\n \"item_additional_id\": null,\n \"option_info\": null,\n \"input_option_info\": null,\n \"warehouse\": [\n {\n \"shop_order_item_warehouse\": \"698\",\n \"soiw_itemid\": \"1110\",\n \"warehouse_name\": \"Secondary Warehouse\",\n \"warehouse_identifier\": \"secondary\",\n \"quantity\": \"1\",\n \"bin_location\": null,\n \"drop_shipper_id\": \"1\"\n }\n ],\n \"quantity_shipped\": \"1\",\n \"quantity_to_ship\": 0,\n \"quantity_returned\": 0,\n \"quantity_to_return\": \"1\",\n \"customization_info\": null,\n \"friendly_url\": \"\",\n \"images\": null\n }\n ],\n \"tracking_numbers\": [\n {\n \"shop_order_ship_trackingid\": \"1086\",\n \"sost_orderid\": \"101769\",\n \"tracking_num\": \"1234567890\",\n \"date_created\": \"2018-06-10 14:29:37\",\n \"email_sent\": null,\n \"email_sent_date\": null,\n \"balancemaxx_tracking_sent\": \"0\",\n \"balancemaxx_tracking_sent_date\": null,\n \"label_cost\": null,\n \"label_img\": null,\n \"overload_ship_weight_total\": null,\n \"length_inches\": \"0\",\n \"width_inches\": \"0\",\n \"height_inches\": \"0\",\n \"carrier_name\": \"FedEx\",\n \"carrier_method\": \"NextDay\",\n \"is_amazon_fba\": \"0\",\n \"is_residential\": \"0\",\n \"use_negotiated\": \"0\",\n \"worldship_downloaded\": \"0\",\n \"standard_downloaded\": \"0\",\n \"signature_type\": null,\n \"is_delivered\": \"0\",\n \"estimated_delivery\": null,\n \"delivery_time\": null,\n \"tracking_activity_summary\": null,\n \"is_ups\": \"0\",\n \"is_fedex\": \"0\",\n \"is_stamps\": \"0\",\n \"should_still_check_tracking\": \"1\",\n \"last_tracking_activity_check\": \"2018-06-10 14:29:37\",\n \"carrier_will_pick_up\": \"0\",\n \"declared_value\": null,\n \"external_shipment_id\": null,\n \"is_walmart_dsv_ship_to_store\": \"0\",\n \"walmart_asn\": null,\n \"usps_zone\": null,\n \"package_size_name\": null,\n \"packing_slip_id\": null,\n \"order_source\": \"Groupon\",\n \"external_order_num\": \"1000-048073-662360\",\n \"shop_order_siteareaid\": \"16\",\n \"package_items\": [\n {\n \"shop_order_ship_tracking_itemid\": \"1168\",\n \"sosti_trackingid\": \"1086\",\n \"sosti_itemid\": \"1110\",\n \"quantity_shipped\": \"1\",\n \"product_name\": \"Twinings Earl Grey Tea 24 ct\",\n \"ship_weight\": \"0.00\",\n \"external_itemid\": \"155239\",\n \"sku\": \"08756-1\",\n \"ship_length_inches\": \"0.00\",\n \"ship_width_inches\": \"0.00\",\n \"ship_height_inches\": \"0.00\",\n \"quantity\": \"1\",\n \"item_upc\": null,\n \"item_isbn\": null,\n \"item_asin\": null,\n \"item_gtin\": null,\n \"item_ean\": null,\n \"item_additional_id\": null,\n \"sku_custom_data\": null\n }\n ],\n \"tracking_activity\": null\n }\n ],\n \"coupons\": null,\n \"rma_numbers\": [1,2,3],\n \"notes\": null,\n \"email_drop_shipper_pos\": null,\n \"tasks\": null,\n \"additional_info\": null\n}"
}
]File Search - Advanced Group
Request
curl --location --request GET '{{api_url}}/data_bridge/files/search?limit&limit_start&sort&search=[{"search_type":"group","group_operator":"and","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"top_level_sku"},{"search_type":"single","data_name_condition_type":"eq","data_name_value":"price","data_value_condition_type":"lt","data_value_value":"100"}]},{"search_type":"group","group_operator":"and","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"top_level_sku"},{"search_type":"single","data_name_condition_type":"eq","data_name_value":"price","data_value_condition_type":"lt","data_value_value":"100zz.00"}]},{"search_type":"single","data_name_condition_type":"eq","data_name_value":"price","data_value_condition_type":"lt","data_value_value":"22222"},{"search_type":"group","group_operator":"and","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_sku_search"},{"search_type":"group","group_operator":"or","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level1_child_1"},{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level1_child_2"}]},{"search_type":"group","group_operator":"or","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level2_child_1"},{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level2_child_2"}]}]},{"search_type":"group","group_operator":"and","searches":[{"search_type":"group","group_operator":"or","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level3_child_1"},{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level3_child_2"}]},{"search_type":"group","group_operator":"or","searches":[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level4_child_1"},{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_level4_child_2"}]},{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_sku_search"}]}]' \
--header 'Authorization: Bearer {{auth_token}}'Response 204 No Content
No response body.
File Search - Single
Request
curl --location --request GET '{{api_url}}/data_bridge/files/search?limit&limit_start&sort&search=[{"search_type":"single","data_name_condition_type":"starts_with","data_name_value":"sku","data_value_condition_type":"eq","data_value_value":"second_sku_search"}]' \
--header 'Authorization: Bearer {{auth_token}}'Response 204 No Content
No response body.
