Technology Blog Posts by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Harshhith
Explorer
808

In order to Create Delta for standard API:

Go to product master standard API in Business Accelerator Hub then click on tryout option.

Harshhith_0-1722237268931.png

 

 

Now, we have to configure our system environment here as shown below

Harshhith_1-1722237269045.png

Harshhith_2-1722237268900.png

 

Harshhith_3-1722237268970.png

Harshhith_4-1722237269019.png

And after successfully configuring Now you can tryout any of these operations in Standard API

Harshhith_5-1722237268937.png

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

Harshhith_6-1722237268967.png

And Filter out records based on delta pointer(Lastchangedate)as shown below

Harshhith_7-1722237269031.pngHere 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

Harshhith_8-1722237269057.png

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

Harshhith_9-1722237269023.png

Now we can check data by taking URL till highlighted part and run OData in PowerBI

Harshhith_10-1722237269074.png

 

Now in Power BI, Select OData feed and add the required URL

Harshhith_11-1722237269079.png

 

Harshhith_12-1722237269098.png

 

And we can see required delta records here

Harshhith_13-1722237269106.png

 

 

Labels in this area