Infor

App · 6 actions

Read and update Infor M3 customers and run any M3 API transaction through Infor OS.

Actions

ActionWhat it does
Get current userGet the M3 user the connection signs in as, with its default company and division.
Get customerGet a customer's name and address.
List customersList customers in customer number order.
List transaction output fieldsList the fields an M3 API transaction returns, with each field's description, type and length.
Run M3 API transactionRun 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 customerChange 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 numbercustomer_numbertextRequired
M3 customer number (CUNO), such as from List customers.
Companycompanytext
M3 company number, such as 100. Leave empty to use the service account's default company.
Divisiondivisiontext
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 numberstarting_customertext
Customer number to start from. Leave empty to start at the first customer.
Max rowsmax_recordsnumber
Most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
Companycompanytext
M3 company number, such as 100. Leave empty to use the service account's default company.
Divisiondivisiontext
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 programprogramtextRequired
M3 API program, such as CRS610MI for customers. M3's API Repository lists them.
TransactiontransactiontextRequired
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 programprogramtextRequired
M3 API program, such as CRS610MI for customers. M3's API Repository lists them.
TransactiontransactiontextRequired
Transaction of that program, such as LstByNumber or GetBasicData.
Inputsinputsobject
The transaction's input fields and values, such as CUNO with a customer number.
Output fieldsoutput_fieldslist
M3 field names to return, such as CUNO and CUNM. Leave empty for all of them.
Max rowsmax_recordsnumber
Most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
Companycompanytext
M3 company number, such as 100. Leave empty to use the service account's default company.
Divisiondivisiontext
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 numbercustomer_numbertextRequired
M3 customer number (CUNO), such as from List customers.
Namenametext
Customer name (CUNM).
Address line 1address_line_1text
First address line (CUA1).
Address line 2address_line_2text
Second address line (CUA2).
Address line 3address_line_3text
Third address line (CUA3).
Address line 4address_line_4text
Fourth address line (CUA4).
Towntowntext
Town or city (TOWN).
Countrycountrytext
M3 country code (CSCD), such as US or SE.
Companycompanytext
M3 company number, such as 100. Leave empty to use the service account's default company.
Divisiondivisiontext
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"
    }
  }
}

On this page