public async Task <IActionResult> GetRecords()
{
//var count = await _api.GetRecordsAsync(
// table: "Addresses",
// filter: "Postal_Code IS NOT NULL",
// select: "COUNT(Addresses.Postal_Code) AS RecordCount, Addresses.Postal_Code AS Zip",
// groupBy: "Postal_Code",
// having: "COUNT(Addresses.Postal_Code) > 1000"
// );
//var contactData = await _api.GetRecordAsync(
// table: "Contacts",
// id: 1,
// select: "Contacts.*, Household_ID_Table.*, Household_ID_Table_Address_ID_Table.*");
// Get Top 5 Addresses and return as model
return(View(
await _api.GetRecordsAsync <AddressModel>(
table: "Addresses",
top: 5,
skip: 10,
filter: "Postal_Code IS NOT NULL AND [State/Region] IS NOT NULL",
select: "Addresses.*",
orderBy: "Postal_Code"
)
));
}
