Ricerca
Chiudere
  1. Benvenuto
  2. I Forum
  3. API users
  4. Result API list query calls order by different fields
Elenco dei foro Elenco dei messaggi

Result API list query calls order by different fields

  • akacfa
    akacfa 100% (51472x)
    PRO ultimate

    60 messaggi

    Paesi Bassi

    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
    Amministratore
    @thomas

    348 messaggi

    Belgio

    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
    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
    akacfa 100% (51472x)
    PRO ultimate

    60 messaggi

    Paesi Bassi

    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
    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
    Amministratore
    @thomas

    348 messaggi

    Belgio

    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
    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 messaggi

    Paesi Bassi

    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
    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 messaggi

    Paesi Bassi

    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
  • Account eliminato
    Account eliminato

    0 messaggi

    Belgio

    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
    Le informazioni non sono più disponibili perché l'account di questo utente è stato eliminato (Regolamento RGPD).

Unisciti alla community di collezionisti!

Registrati Login