Hello! Could someone point me to documentation on how to get the "Refund Of" information returned in an API call when a Sale is a refund of another Sale? Screenshot attached for reference. Thanks in advance!
Still looking for a response on this. Is this information available via Lightspeed's API?
Thanks for the question! To get this information you'll want to do something like this:
This will give you all sales that have sale lines associated with a parent sale (i.e. a refund).
You will have to loop through them and perhaps create a dictionary/database record with the information
You can then use an IN query from the results to retrieve the list of related saleIDs.
To do this, run this query
Where parentIDArray is the list of all the parentIDs you retrieved from the previous query
Relate them using logic/database lookups and then you have your matches]
Hope this helps!