Query API for All Items Whose Specific CustomFieldValue changed in the past 24 hours

jzbgjzbg Member Posts: 1
edited April 2019 in Development

When I am hitting the /Account/{accountID}/Item API method resource I want to know of the best query I can run to obtain only the items whose specific CustomFieldValue changed in the past 24 hour period.

Currently when I attempt to do this using the .timeStamp I will get back all of the updated products in that timeframe.

For example...


This above request works and returns the data I need but it is sending back all items that have been updated due to any action, it also sends back all of the CustomFieldValues.

I only want to get the items back that have had a specific CustomFieldValue that was modified.

So this is kinda a pseudo example of what I'm going after...


What is the best way to accomplish this?

Thank you!

Post edited by jzbg on

1 comment

  • Adrian SamuelAdrian Samuel Moderator, Lightspeed Staff Posts: 654 moderator

    Hey @jzbg, unfortunately you're not able to do this with the API. The best you're going to do is to store the payload of the data in a DB and then periodically check the API for changes, recording the timestamp.

    Adrian Samuel

    Software Developer

    Lightspeed HQ

Sign In or Register to comment.