Infor
App · 6 actions
Read and update Infor M3 customers and run any M3 API transaction through Infor OS.
Actions
| Action | What it does |
|---|---|
| Get current user | Get the M3 user the connection signs in as, with its default company and division. |
| Get customer | Get a customer's name and address. |
| List customers | List customers in customer number order. |
| List transaction output fields | List the fields an M3 API transaction returns, with each field's description, type and length. |
| Run M3 API transaction | Run any M3 API transaction your service account may use, such as adding an order line or reading stock, and get the rows it returns. |
| Update customer | Change a customer's name or address. |
Get current user
Get the M3 user the connection signs in as, with its default company and division.
Inputs
None.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"record": {
"CONO": "example",
"DIVI": "example",
"NAME": "example",
"USID": "example"
}
}
}Get customer
Get a customer's name and address.
Inputs
- Customer number
customer_numbertextRequired - M3 customer number (CUNO), such as from List customers.
- Company
companytext - M3 company number, such as 100. Leave empty to use the service account's default company.
- Division
divisiontext - M3 division code, such as AAA. Leave empty to use the service account's default division.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"record": {
"CSCD": "example",
"CUA1": "example",
"CUA2": "example",
"CUA3": "example",
"CUA4": "example",
"CUNM": "example",
"CUNO": "example",
"TOWN": "example"
}
}
}List customers
List customers in customer number order. To read the next page, start from the last customer number returned.
Inputs
- Start from customer number
starting_customertext - Customer number to start from. Leave empty to start at the first customer.
- Max rows
max_recordsnumber - Most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
- Company
companytext - M3 company number, such as 100. Leave empty to use the service account's default company.
- Division
divisiontext - M3 division code, such as AAA. Leave empty to use the service account's default division.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"count": 1,
"records": [
{
"CUA1": "example",
"CUNM": "example",
"CUNO": "example",
"PHNO": "example",
"STAT": "example",
"TOWN": "example",
"YREF": "example"
}
]
}
}List transaction output fields
List the fields an M3 API transaction returns, with each field's description, type and length.
Inputs
- API program
programtextRequired - M3 API program, such as CRS610MI for customers. M3's API Repository lists them.
- Transaction
transactiontextRequired - Transaction of that program, such as LstByNumber or GetBasicData.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"count": 1,
"records": [
{
"FLDS": "example",
"FLNM": "example",
"LENG": "example",
"TYPE": "example"
}
]
}
}Run M3 API transaction
Run any M3 API transaction your service account may use, such as adding an order line or reading stock, and get the rows it returns.
Inputs
- API program
programtextRequired - M3 API program, such as CRS610MI for customers. M3's API Repository lists them.
- Transaction
transactiontextRequired - Transaction of that program, such as LstByNumber or GetBasicData.
- Inputs
inputsobject - The transaction's input fields and values, such as CUNO with a customer number.
- Output fields
output_fieldslist - M3 field names to return, such as CUNO and CUNM. Leave empty for all of them.
- Max rows
max_recordsnumber - Most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
- Company
companytext - M3 company number, such as 100. Leave empty to use the service account's default company.
- Division
divisiontext - M3 division code, such as AAA. Leave empty to use the service account's default division.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"count": 1,
"records": [
{}
]
}
}Update customer
Change a customer's name or address. Fields left empty keep their value.
Inputs
- Customer number
customer_numbertextRequired - M3 customer number (CUNO), such as from List customers.
- Name
nametext - Customer name (CUNM).
- Address line 1
address_line_1text - First address line (CUA1).
- Address line 2
address_line_2text - Second address line (CUA2).
- Address line 3
address_line_3text - Third address line (CUA3).
- Address line 4
address_line_4text - Fourth address line (CUA4).
- Town
towntext - Town or city (TOWN).
- Country
countrytext - M3 country code (CSCD), such as US or SE.
- Company
companytext - M3 company number, such as 100. Leave empty to use the service account's default company.
- Division
divisiontext - M3 division code, such as AAA. Leave empty to use the service account's default division.
Outputs
dataobject- The response from Infor.
Example output
{
"data": {
"record": {
"CSCD": "example",
"CUA1": "example",
"CUA2": "example",
"CUA3": "example",
"CUA4": "example",
"CUNM": "example",
"CUNO": "example",
"TOWN": "example"
}
}
}