Result API list query calls order by different fields

  • akacfa

    60 Beiträge

    Niederlande

    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.
    Link (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
    Administrator

    348 Beiträge

    Belgien

    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.
    Link (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
    • Erstellt am 24.01.2021 um 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: Link (https)

    Best Regards,
    --
    Thomas
    Delcampe Team
  • akacfa

    60 Beiträge

    Niederlande

    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: Link (https)

    Best Regards,
    --
    Thomas
    Delcampe Team
    • Erstellt am 25.01.2021 um 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
    Administrator

    348 Beiträge

    Belgien

    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
    • Erstellt am 25.01.2021 um 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

    60 Beiträge

    Niederlande

    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
    • Erstellt am 27.01.2021 um 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

    60 Beiträge

    Niederlande

    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:
    Link (https)

    itemAuctionClosedSold:
    Link (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
  • Konto gelöscht
    Konto gelöscht

    0 Beiträge

    Belgien

    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:
    Link (https)

    itemAuctionClosedSold:
    Link (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
    • Erstellt am 15.02.2021 um 02:05
    • #1246861
    Die Informationen sind nicht mehr verfügbar, da das Konto dieses Benutzers gelöscht wird (DSGVO-Grundverordnung).

Werden Sie Mitglied der Sammler-Community!

Anmelden Einloggen