Recherche
Fermer
  1. Accueil
  2. Forum
  3. API users
  4. Result API list query calls order by different fields
Liste des forums Liste des messages

Result API list query calls order by different fields

  • akacfa
    akacfa 100% (51472x)
    PRO ultimate

    60 messages

    Pays-Bas

    Dear Delcampe Support!

    We would like to use the itemFixedPriceClosedSold, itemFixedPriceClosed and the auction variants of API calls to get the latest items ordered by time.

    Checking the documentation I have realised that the "order" paramter is currently only mean: order by id_item.
    Lien (https)

    Is there any additional parameter that we can use calling the related APIs to get the result ordered by other fields?
    For example: &order_by=date_end

    Best regards,
    Gergely
  • @thomas
    Administrateur
    @thomas

    348 messages

    Belgique

    Dear Delcampe Support!

    We would like to use the itemFixedPriceClosedSold, itemFixedPriceClosed and the auction variants of API calls to get the latest items ordered by time.

    Checking the documentation I have realised that the "order" paramter is currently only mean: order by id_item.
    Lien (https)

    Is there any additional parameter that we can use calling the related APIs to get the result ordered by other fields?
    For example: &order_by=date_end

    Best regards,
    Gergely
    • Posté le 24 janv. 2021 à 15:50
    • #1238944
    Hello Gergely,

    Currently, only the order of the dates of creation can be changed (from the oldest to the most recent item and vice versa). Discussions are underway to add other orders as parameters.

    Sorting by end date also seems to me more relevant for closed items. I therfore encourage you to fill in this form to enhance the feature: Lien (https)

    Best Regards,
    --
    Thomas
    Delcampe Team
  • akacfa
    akacfa 100% (51472x)
    PRO ultimate

    60 messages

    Pays-Bas

    Hello Gergely,

    Currently, only the order of the dates of creation can be changed (from the oldest to the most recent item and vice versa). Discussions are underway to add other orders as parameters.

    Sorting by end date also seems to me more relevant for closed items. I therfore encourage you to fill in this form to enhance the feature: Lien (https)

    Best Regards,
    --
    Thomas
    Delcampe Team
    • Posté le 25 janv. 2021 à 05:54
    • #1239073
    Hello Thomas,

    Thank you, I have filled the feature request form.
    I hope that it will be realized soon!

    Now how can I query using API calls our sold or closed items of the last week?
    Currently the only way I see is query the whole data set and filter by "date_end" field in our side.
    Do you have an alternative more efficient proposal?

    Best regards,
    Gergely
  • @thomas
    Administrateur
    @thomas

    348 messages

    Belgique

    Hello Thomas,

    Thank you, I have filled the feature request form.
    I hope that it will be realized soon!

    Now how can I query using API calls our sold or closed items of the last week?
    Currently the only way I see is query the whole data set and filter by "date_end" field in our side.
    Do you have an alternative more efficient proposal?

    Best regards,
    Gergely
    • Posté le 25 janv. 2021 à 15:06
    • #1239256
    Hello Gergely,

    I can think of no more effective way to offer you.

    The simplest way to avoid having to do this is to store the results of the notifications(Seller_Item_Close_Sold, Seller_Item_Close_Unsold, Seller_Item_Close_Manually).

    Best Regards,
    --
    Thomas
    Delcampe Team
  • akacfa
    akacfa 100% (51472x)
    PRO ultimate

    60 messages

    Pays-Bas

    Hello Gergely,

    I can think of no more effective way to offer you.

    The simplest way to avoid having to do this is to store the results of the notifications(Seller_Item_Close_Sold, Seller_Item_Close_Unsold, Seller_Item_Close_Manually).

    Best Regards,
    --
    Thomas
    Delcampe Team
    • Posté le 27 janv. 2021 à 11:58
    • #1239793
    Hello Thomas,

    We are already storing the results of the different notifications, but because of some unknown reasons we are missing some of them. So, as a complement method we would like to query periodically the latest data also.

    We would be happy if this additional order_by field get implementet in the near future!

    Best regards,
    Gergely
  • akacfa
    akacfa 100% (51472x)
    PRO ultimate

    60 messages

    Pays-Bas

    Hello Thomas,

    Is there any news when new parameters will be developed for the list querying APIs?

    Investigating the problem we noted that an additional startTime and endTime range filtering should be very useful for example to query the latest ended or listed items.

    Example:

    itemFixedPriceOpened:
    Lien (https)

    itemAuctionClosedSold:
    Lien (https)

    Where YmdHis is the datetime in Delcampe timezone (es.:20210215072000)
    Y: A full numeric representation of a year, 4 digits
    m: Numeric representation of a month, with leading zeros
    d: Day of the month, 2 digits with leading zeros
    H: 24-hour format of an hour with leading zeros
    i: Minutes with leading zeros
    s: Seconds with leading zeros

    I have reported this feature request also.

    Best regards,
    Gergely
  • Compte supprimé
    Compte supprimé

    0 message

    Belgique

    Hello Thomas,

    Is there any news when new parameters will be developed for the list querying APIs?

    Investigating the problem we noted that an additional startTime and endTime range filtering should be very useful for example to query the latest ended or listed items.

    Example:

    itemFixedPriceOpened:
    Lien (https)

    itemAuctionClosedSold:
    Lien (https)

    Where YmdHis is the datetime in Delcampe timezone (es.:20210215072000)
    Y: A full numeric representation of a year, 4 digits
    m: Numeric representation of a month, with leading zeros
    d: Day of the month, 2 digits with leading zeros
    H: 24-hour format of an hour with leading zeros
    i: Minutes with leading zeros
    s: Seconds with leading zeros

    I have reported this feature request also.

    Best regards,
    Gergely
    • Posté le 15 févr. 2021 à 02:05
    • #1246861
    Les informations ne sont plus disponibles car le compte de cet utilisateur est supprimé (Règlement RGPD)

Rejoignez la communauté des collectionneurs !

S'inscrire Se connecter