on 2024 Jul 25 10:41 AM
In order to Create Delta for standard API:
Go to product master standard API in Business Accelerator Hub then click on tryout option.
Now, we have to configure our system environment here as shown below
And after successfully configuring Now you can tryout any of these operations in Standard API
Now in order to get delta, we have to take a delta pointer based on the fields in standard API. In this case I’m taking Lastchangedate field as delta pointer
And Filter out records based on delta pointer(Lastchangedate)as shown below
Here the logic is: LastChangeDate ge datetime'2024-01-14T00:00:00’ And it says lastchangedate is greater than or equals to 2024-01-14 and also there are other logics as well: LastChangeDate ge datetime'2024-06-13T00:00:00' and LastChangeDate lt datetime'2024-06-14T00:00:00' and it only gives records between 14th june to 13th june .
So After initializing this logic run as shown below
we get records that are changed on or after 14th January 2024 in OData URL itself and it gives count of how many records are present as shown below
Now we can check data by taking URL till highlighted part and run OData in PowerBI
Now in Power BI, Select OData feed and add the required URL
And we can see required delta records here
Hello,
From my understanding this is like sharing information rather than a question.
If so, suggest you choose to create Blog.
Thanks & Best Regards,
Owen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
12 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.