standalonePrices

Query standalone prices with a `where` predicate and paging.

Use it in a workflow

Add a step and choose the Commercetools connector.
Pick the standalonePrices action (under Standalone).
Fill in the fields below, then reference the result from later steps as {{standaloneprices.response.data}}.

Query

This is the query the action sends by default. Edit it in the step's Query field to change which fields come back.

graphql

query StandalonePrices($where: String, $sort: [String!], $limit: Int, $offset: Int) {
  standalonePrices(where: $where, sort: $sort, limit: $limit, offset: $offset) {
    offset
    count
    total
    exists
    results {
      id
      version
      key
      sku
      value {
        type
        currencyCode
        centAmount
        fractionDigits
      }
      country
      customerGroupRef {
        typeId
        id
      }
      customerGroup {
        id
        version
        name
        key
        createdAt
        lastModifiedAt
        custom
        createdBy
        lastModifiedBy
      }
      channelRef {
        typeId
        id
      }
      channel {
        id
        version
        key
        roles
        nameAllLocales
        descriptionAllLocales
        address
        geoLocation
        createdAt
        lastModifiedAt
        reviewRatingStatistics
        custom
        createdBy
        lastModifiedBy
      }
      validFrom
      validUntil
      tiers {
        minimumQuantity
        value
      }
      discounted {
        value
        discountRef
        discount
      }
      staged {
        value
        discounted
      }
      custom {
        typeRef
        type
      }
      active
      recurrencePolicyRef {
        typeId
        id
      }
      recurrencePolicy {
        id
        version
        key
        nameAllLocales
        descriptionAllLocales
        schedule
        createdAt
        lastModifiedAt
        createdBy
        lastModifiedBy
      }
      createdAt
      lastModifiedAt
      createdBy {
        isPlatformClient
        clientId
        externalUserId
        anonymousId
        customerRef
        userRef
        associateRef
        attributedTo
      }
      lastModifiedBy {
        isPlatformClient
        clientId
        externalUserId
        anonymousId
        customerRef
        userRef
        associateRef
        attributedTo
      }
    }
  }
}

Variables

Pass these as a JSON object in the step's Variables field.

wherestring

sortarray<string>

limitnumber

offsetnumber

json

{
  "where": "string",
  "sort": [
    "string"
  ],
  "limit": 0,
  "offset": 0
}

Response

Read the result with {{standaloneprices.response.data.data.standalonePrices}}. If the API returns errors, the step fails and they are at {{standaloneprices.response.data.errors}}.

offsetnumber

countnumber

totalstring

existsboolean

resultsarray<object>

idobject

versionobject

keyobject

skuobject

valueobject

countryobject

customerGroupRefobject

customerGroupobject

channelRefobject

channelobject

validFromobject

validUntilobject

tiersobject

discountedobject

stagedobject

customobject

activeobject

recurrencePolicyRefobject

recurrencePolicyobject

createdAtobject

lastModifiedAtobject

createdByobject

lastModifiedByobject

Need more? See the Commercetools guide for connection setup and behaviour shared by every action.

Was this page helpful?