This time I am using the following manual:
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/extracting-sap-data-using-odata-part-7-delta-extraction-using/bc-p/4202197#M976
We are talking about this picture:
What are we trying to do:
- Lookup: Get a table from source
- Set variable: Check if the table is empty
- If empty, write an empty value to variable
- If filled, get the latest value from column DeltaToken with the help of column CreatedAt
My idea (I assumed that the DeltaToken does increase with time):
@if(equals(activity('ll_delta').output.count, 0), '', max(activity('ll_delta').output.value.DeltaToken))
Error:
The expression 'if(equals(activity('ll_delta').output.count, 0), '', max(activity('ll_delta').output.value.DeltaToken))' cannot be evaluated because property 'DeltaToken' cannot be selected. Array elements can only be selected using an integer index.
His idea:
Order the DeltaToken by its CreatedAt-Time and pull the latest
–> Would anyone mind helping me to achieve this goal? I would appreciate your help