Search for customers in Infor M3 using the M3 Search API (CRS610MI/SearchCustomer). Supports advanced SQRY query syntax with field:value pairs and wildcards (e.g. “CUNM:MADISON* CUNO:2* RGDT:20210714 ECAR:NC RESP:WWONG”).
Get delivery header information from Infor M3 (MWS410MI/GetHead). Returns delivery details such as status, customer, warehouse, and shipping information.
Get item type and additional item data from Infor M3 (MMS019MI/Get). Returns extended item master attributes such as item type, category, and classification.
List material planning data by item and warehouse from Infor M3 (MMS080MI/LstMtPlByItmWhs). Returns planned orders, demand, and supply information for MRP.
Get picking list header information from Infor M3 (OIS390MI/GetHead). Returns picking list details including status, warehouse, and associated order information.
Search for customers in Infor M3 using the M3 Search API (CRS610MI/SearchCustomer). Supports advanced SQRY query syntax with field:value pairs and wildcards (e.g. “CUNM:MADISON* CUNO:2* RGDT:20210714 ECAR:NC RESP:WWONG”).Parameters:
Parameter
Type
Required
Default
Description
SQRY
string
Yes
—
M3 search query string. Use field:value pairs separated by spaces. Supports wildcards (). Example: “CUNM:MADISON CUNO:2* RGDT:20210714 ECAR:NC”
maxRecords
number
No
50
Maximum number of records to return
dateFormat
string
No
"YMD8"
Date format for date fields (e.g. YMD8)
excludeEmpty
boolean
No
false
Exclude empty fields from results
rightTrim
boolean
No
true
Right trim field values
extendedResult
boolean
No
false
Include extended result metadata
Show inputSchema
{ "type": "object", "properties": { "PCID": { "type": "string", "description": "Pink Connect ID" }, "SQRY": { "type": "string", "description": "M3 search query string. Use field:value pairs separated by spaces. Supports wildcards (*). Example: \"CUNM:MADISON* CUNO:2* RGDT:20210714 ECAR:NC\"" }, "maxRecords": { "type": "number", "default": 50, "description": "Maximum number of records to return" }, "dateFormat": { "type": "string", "default": "YMD8", "description": "Date format for date fields (e.g. YMD8)" }, "excludeEmpty": { "type": "boolean", "default": false, "description": "Exclude empty fields from results" }, "rightTrim": { "type": "boolean", "default": true, "description": "Right trim field values" }, "extendedResult": { "type": "boolean", "default": false, "description": "Include extended result metadata" } }, "required": [ "PCID", "SQRY" ]}
Get delivery header information from Infor M3 (MWS410MI/GetHead). Returns delivery details such as status, customer, warehouse, and shipping information.Parameters:
Get item type and additional item data from Infor M3 (MMS019MI/Get). Returns extended item master attributes such as item type, category, and classification.Parameters:
List material planning data by item and warehouse from Infor M3 (MMS080MI/LstMtPlByItmWhs). Returns planned orders, demand, and supply information for MRP.Parameters:
Get picking list header information from Infor M3 (OIS390MI/GetHead). Returns picking list details including status, warehouse, and associated order information.Parameters: