Skip to content
Pricefx REST API
/Pricefx API Reference/
/
Upload a File to PX/CX/SX

The Pricefx Backend API

Pricefx REST API Reference

Download OpenAPI description
pricefx-server_openapi.json
pricefx-server_openapi.yaml
Overview
URL
https://www.pricefx.com
Pricefx
documentation@pricefx.com
Languages
Servers
Mock server
https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi
URL:
https://{baseUrl}/pricefx/{partition}

General

Operations

Products

Operations

Product Extensions

Operations

Product Image

Operations

Customers

Operations

Customer Extensions

Operations

Sellers

Operations

Seller Extensions

Operations

Import a File

Request

Uploads a CSV or XLSX file to the Seller Extensions table.
Delete the upload slot using the /uploadmanager.deleteslot/{slot_id} (Delete an Upload Slot) endpoint after the file has been uploaded.

Security
basic or X-PriceFx-jwt
Path
SXCategorystringrequired

The Seller Extension category (the Name from the Seller Master Extension table).

slotIdstringrequired

The ID that is returned by the /uploadmanager.newuploadslot (Create an Upload Slot) endpoint.

Query
truncatestring

Set to false to add records from the file as new lines to the existing data. Set to true to delete all previous records in the SX table.

Bodymultipart/form-data
fileNamestring(binary)
curl -i -X POST \
  -u <username>:<password> \
  'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/importfile/SX/{SXCategory}/{slotId}?truncate=string' \
  -H 'Content-Type: multipart/form-data' \
  -F fileName=string

Responses

Accepted

Upload a File to PX/CX/SX

Request

Uploads CSV, or XLSX file to Product Extensions, Customer Extensions, or Seller Extensions table.

Security
basic or X-PriceFx-jwt
Path
TypeCodestringrequired

Type code of the table you want to upload the file to.

Enum"PX""CX""SX"
Example: PX
targetstringrequired

The name of the PX/CX/SX table.

uploadSlotIdstringrequired

id of the upload slot. Use the uploadslotmanager.newuploadslot endpoint to retrieve the id.

Example: 5000
Query
truncatestring

Set to true to overwrite existing data, or false to add new lines to existing data.

Enum"true""false"
Example: truncate=false
Bodymultipart/form-data
filestring(binary)

Provide the file (CSV, or XLSX format) you want to upload.

curl -i -X POST \
  -u <username>:<password> \
  'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/importfile/PX/{target}/5000?truncate=false' \
  -H 'Content-Type: multipart/form-data' \
  -F file=string

Responses

A general response that contains data property with a content depending on returned objects (e.g., Product master table fields when calling the /fetch/P endpoint). Can be null.

Bodyapplication/json
responseobject
Response
application/json
{
  "response": {
    "node": "string",
    "data": null,
    "status": 0,
    "startRow": 0,
    "endRow": 0
  }
}

Condition Records

Operations

Competition Data

Operations

Imports

Operations

Data Change Requests

Operations

Lookup Tables / Company Parameters

Operations

User Admin

Operations

Authentication

Operations

Admin Tools

Operations

Logics

Operations

Logs

Operations

Custom Forms

Operations

Calculated Field Sets

Operations

Jobs & Tasks

Operations

Data Manager

Operations

Actions

Operations

Action Types

Operations

Price Lists

Operations

Manual Price Lists

Operations

Live Price Grids

Operations

Calculation Grids

Operations

Visual Configuration

Operations

Quotes

Operations

Contracts (Agreements & Promotions)

Operations

Visual Configuration

Operations

Rebate Agreements

Operations

Rebate Calculations

Operations

Rebate Record Group

Operations

Sales Compensations

Operations

Claim Types

Operations

Claims

Operations

Optimization

Operations

Workflow

Operations

Workflow Delegation

Operations

Attachments

To upload a file you need to perform the following actions using endpoints in this category:

  1. Create an Upload Slot
  2. Upload a File
  3. Delete an Upload Slot
Operations

Product Image

Operations

Configuration

Operations

Internationalization

Operations

Metadata

Operations

Clicmanager

Clicmanager (CLIC = "Calculable Line Item Collection") endpoints are used in the REACT version to manipulate Quote/Agreements & Promotions (Contract)/Rebate Agreement/Compensation Plan objects.

Operations

Comments

Operations

Notifications

Operations

Heartbeat

Operations

Key-Value Store

See the Key-Value Database Storage Knowledge Base article for more details.

Operations

Entities

Here you can find all fields of the corresponding entity (represented by the type code).
Use the /metadata.describe endpoint to find out the correct data type of the field that is used in your partition.

otherSchemas

Schemas