Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Функция

http://localhost:2001/apix1/SupplierPrice

Expand
titleПример результатов
Code Block
 {
            "$id": 1,
            "@xdata.type": "XData.Default.Price",
            "Id": 542,
            "Title": "Thomas",
            "LastUpdate": null,
            "State": null,
            "Curr": null,
            "PriceType": 1,
            "CatId": 17,
            "Label1": null,
            "Label2": null,
            "Label3": null,
            "Label4": null,
            "Label5": null,
            "SetNotExists": 1,
            "PreSource": null,
            "FixCostPrice": "",
            "FixExistsPrice": "",
            "ClearFixPrice": 0,
            "ClearExists": 0,
            "ConnectOption": null,
            "FilePath": "{%APPFOLDER%}\\files\\2_ price\\Thomas  11.11.2019 Прайс.xlsx",
            "DoNotLoad": 0,
            "FnTemplate": "Thomas  *.*.* Прайс.xlsx",
            "Info": null,
            "IsActive": 1,
            "FnCurrent": "Thomas  11.11.2019 Прайс.xlsx",
            "FnLastHash": "2020-01-10T14:21:26.775",
            "IsSelected": 0,
            "FnCurrHash": "2019-11-15T11:30:16",
            "FnFolder": "{%APPFOLDER%}\\files\\2_ price",
            "CurRate": null,
            "FixCurRate": null,
            "IsNew": 0,
            "ErrCount": 0,
            "ImpLog": "[2020-01-10 14-21-25] Инициализация... Ок\r\n[2020-01-10 14-21-25] Подготовка файла...\r\n[2020-01-10 14-21-26] Подготовка позиций... Ок\r\n[2020-01-10 14-21-26] Загрузка товаров...\r\n[2020-01-10 14-21-26] Обработка скидок категорий...\r\n[2020-01-10 14-21-26] Обработка связанных товаров...\r\n[2020-01-10 14-21-26] Импорт завершен\r\n",
            "FixCostField": 0,
            "FixExistsField": 0,
            "WarnCount": 0,
            "UseRc": 1,
            "ImporterInfo": null,
            "AgentDb": "",
            "CopyToTemp": 0,
            "PassBook": null,
            "PassList": null,
            "PassFile": null,
            "ChkUpdateDay": 0,
            "ChkPriceDay": 0,
            "SetInNull": 0,
            "AutoConnectQn": 0,
            "AutoAddgreenQn": 0,
            "SaveManuf": 0,
            "UsePriceN": null,
            "ExpOnlyIfLoaded": 0,
            "AlreadyExported": 0,
            "SqlBeforeImport": "",
            "SqlAfterImport": "",
            "CurRateFormula": null,
            "FixCurRateFormula": null,
            "DoOpenFile": 0,
            "DoBlockOnError": 0,
            "QnConnectCode": null,
            "QnConnectFilter": null,
            "QnConnectField": null,
            "QnConnectOpt": null,
            "DescPrior": null,
            "PhotoPrior": null,
            "PhotoSplit": null,
            "ImportId": null
        }

...

PriceType тип прайса (1 - поставщик, 2 - конкурент, 3 - поставщик и конкурент, 4 - Другой, 5 - Остатки, 6 - РРЦ, 0 - Основной)

IsActive активный (включен)

Получить все сопоставленные товары прайса:

Code Block
http://localhost:2001/apix1/Supplier?$filter=(PriceId eq 200) and (ProductId gt 0)

где 200 - ИД прайса

Получить прайс по Id:

Code Block
http://localhost:2001/apix1/Supplier?$filter=(Id eq 123)