The Pricefx Backend API

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

curl -i -X POST \
  -u <username>:<password> \
  'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/datamart.sqlquery?timeout=20' \
  -H 'Content-Type: application/json' \
  -d '{
    "operationType": "fetch",
    "startRow": 0,
    "endRow": 10000,
    "data": {
      "sources": {
        "s0": {
          "query": {
            "source": "DM.InvoicesDM",
            "projections": {
              "Month": {
                "expression": "Invoice_DateMonth"
              },
              "Quantity": {
                "expression": "SUM({field})",
                "parameters": {
                  "field": "Sales_Quantity"
                },
                "advancedProjection": true
              }
            },
            "options": {
              "currency": "EUR"
            },
            "filter": {},
            "aggregateFilter": null,
            "dimensionFilters": [
              {
                "Invoice_DateYear": [
                  "2019"
                ]
              }
            ],
            "rollup": true
          }
        },
        "s1": {
          "query": {
            "source": "DM.InvoicesDM",
            "projections": {
              "Month": {
                "expression": "Invoice_DateMonth"
              },
              "Quantity": {
                "expression": "SUM({field})",
                "parameters": {
                  "field": "Sales_Quantity"
                },
                "advancedProjection": true
              }
            },
            "options": {
              "currency": "EUR"
            },
            "filter": {},
            "aggregateFilter": null,
            "dimensionFilters": [
              {
                "Invoice_DateYear": [
                  "2020"
                ]
              }
            ],
            "rollup": true
          }
        }
      },
      "with": {
        "w0": "SELECT Month FROM (VALUES ('\''M01'\''), ('\''M02'\''), ('\''M03'\''), ('\''M04'\''), ('\''M05'\''), ('\''M06'\''), ('\''M07'\''), ('\''M08'\''), ('\''M09'\''), ('\''M10'\''), ('\''M11'\''), ('\''M12'\'')) AS t(Month)"
      },
      "sql": "SELECT w0.Month \"Month\", SUM(s0.quantity) \"Volume 2019\", SUM(s1.quantity) \"Volume 2020\", 100 * (SUM(s1.quantity) / SUM(s0.quantity) - 1.0) \"VolumeΔ%\" FROM w0 LEFT OUTER JOIN s0 ON w0.Month = RIGHT(s0.Month,3) LEFT OUTER JOIN s1 ON w0.Month = RIGHT(s1.Month,3) GROUP BY w0.Month ORDER BY w0.Month"
    }
  }'

curl -i -X POST \
  -u <username>:<password> \
  https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/datamart.getrollups \
  -H 'Content-Type: application/json' \
  -d '{
    "operationType": "fetch",
    "startRow": 0,
    "endRow": null,
    "textMatchStyle": "substring",
    "data": {
      "fieldName": "owner",
      "operator": "equals",
      "value": null,
      "_constructor": "AdvancedCriteria"
    },
    "oldValues": null
  }'

curl -i -X POST \
  -u <username>:<password> \
  https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/datamart.getcharts