[quote=RB;1157]
Can any one tell me which API function returning the promotion products information
[/quote]

What information are you specifically hoping to see returned? Maybe an example could help. :)

[quote=Will Strohl;1158][quote=RB;1157]
Can any one tell me which API function returning the promotion products information
[/quote]

What information are you specifically hoping to see returned? Maybe an example could help. :)[/quote]

I already read the list of promotion items by sql table thanks

I wouldn't recommend directly querying the database in any third-party application. The database is never part of the API and is subject to breaking changes during any and all upgrades.

When this happens, it not only makes the application look bad, but oftentimes also the developer(s) involved - causing the organization to question why they used either in the first place. This scenario becomes dangerous and costly very quickly for all parties.

Alternatively, it's always better to use whatever API options are available.

I already change it from the db to the API it's by the help of the following code and it's working fine thanks

var HccApp = HccAppHelper.InitHccApp();
var all_featuredProducts = HccApp.CatalogServices.Products.FindFeatured(1, 50000);
var listResult = all_featuredProducts.AsEnumerable().OrderByDescending(i => i.CreationDateUtc).Take(3).ToList();