order grid columns

The order grid columns extension point enables you to add columns to the grid on the Sales > Orders page in the Adobe Commerce Admin. This extension point requires an API Mesh for Adobe Developer App Builder instance to retrieve the data to be added to the custom columns.

You can use the aio api-mesh:describe command to retrieve the values of the API key and mesh ID. The key is appended to the mesh endpoint URL.

Example customization

The following example creates custom columns labeled First App Column and Second App Column.

order: {
    gridColumns: {
        data: {
            meshId: 'MESH_ID',
            apiKey: 'API_KEY'
        },
        properties:[
            {
                label: 'First App Column',
                columnId: 'first_column',
                type: 'string',
                align: 'left'
            },
            {
                label: 'Second App Column',
                columnId: 'second_column',
                type: 'integer',
                align: 'left'
            },
            {
                label: 'Third App Column',
                columnId: 'third_column',
                type: 'date',
                align: 'left'
            }
        ]
    }
}
Copied to your clipboard
order: {
    gridColumns: {
        data: {
            meshId: 'MESH_ID',
            apiKey: 'API_KEY'
        },
        properties:[
            {
                label: 'First App Column',
                columnId: 'first_column',
                type: 'string',
                align: 'left'
            },
            {
                label: 'Second App Column',
                columnId: 'second_column',
                type: 'integer',
                align: 'left'
            },
            {
                label: 'Third App Column',
                columnId: 'third_column',
                type: 'date',
                align: 'left'
            }
        ]
    }
}

Sample API Mesh configuration file

The following sample mesh configuration file defines the external source that contains the data to populate in the custom columns.

{
    "meshConfig": {
        "sources": [
            {
                "name": "orders",
                "handler": {
                    "JsonSchema": {
                        "baseUrl": "https://www.example.com",
                        "operations": [
                            {
                                "type": "Query",
                                "field": "orders",
                                "path": "/graphql",
                                "method": "GET",
                                "responseSchema": "./schema.json"
                            }
                        ]
                    }
                }
            }
        ]
    }
} 
Copied to your clipboard
{
    "meshConfig": {
        "sources": [
            {
                "name": "orders",
                "handler": {
                    "JsonSchema": {
                        "baseUrl": "https://www.example.com",
                        "operations": [
                            {
                                "type": "Query",
                                "field": "orders",
                                "path": "/graphql",
                                "method": "GET",
                                "responseSchema": "./schema.json"
                            }
                        ]
                    }
                }
            }
        ]
    }
}

Sample schema file

This sample schema.json file is referenced in the mesh configuration file. It defines the response of the external orderGridColumns query that fetches column data.

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "properties": {
      "orderGridColumns": {
        "type": "object",
        "patternProperties": {
          "^0": {
            "type": "object",
            "properties": {
              "first_column": {
                "type": "string"
              },
              "second_column": {
                "type": "integer"
              },
              "third_column": {
                "type": "integer"
              }
            }
          }
        }
      }
    },
    "required": [
      "orderGridColumns"
    ]
}
Copied to your clipboard
{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "properties": {
      "orderGridColumns": {
        "type": "object",
        "patternProperties": {
          "^0": {
            "type": "object",
            "properties": {
              "first_column": {
                "type": "string"
              },
              "second_column": {
                "type": "integer"
              },
              "third_column": {
                "type": "integer"
              }
            }
          }
        }
      }
    },
    "required": [
      "orderGridColumns"
    ]
}

Parameters

Field	Type	Required	Description
`data.apiKey`	string	Yes	The API key assigned to the GraphQL mesh.
`data.meshId`	string	Yes	The ID of the mesh used to retrieve the column data.
`properties.align`	string	Yes	The alignment of the values in the column. One of `left`, `right`, `center`.
`properties.columnId`	string	Yes	The identifier used in the external dataset to identify the column.
`properties.label`	string	Yes	The label of the column to display.
`properties.type`	string	Yes	The data type of the values in the column. Supported values: `boolean`, `date`, `float`, `integer`, `string`. Date values must be ISO 8601-compliant.