Web API Portal syntax error because table permission settings

[Alkahfi]

Hi All,

So im developing a hierarchy settings for some table with this configuration

so dealer can only access their record, distributor can see the dealer below it but not from the other distributor, and admin can see all of the records, keep in mind dealer is like team or business unit.
the settings on table will be like this

if the dealer lookup is null, then the user is distributor, lookup will be used for parent access system

This what looks like in Portal Table Permission

The filter works, now list will be filtered by own team, but the problem is, i need to do some web api to get some data and have this error

anyone know why this is happen or maybe the solution from this one?

Thanks!

[saudali_25]

Hi @Alkahfi , 

It seems your code has some errors. Can you share your code as well, how you are calling Api. So, you can have better answers?

Thanks,

Saud

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
 

[Alkahfi]

Hi @saudali_25 ,

for the framework im using web api portal from this https://learn.microsoft.com/power-pages/configure/web-api-overview

for the code to calling it, will look like this.

[Lucas001]

Hi @Alkahfi,

I am not sure where you got the code snippet but I use it differently.

This tutorial is helping a lot: https://www.youtube.com/watch?v=5PwLZd_HE30

You have to enable the webapi for the table, create the permission and use the CRUD operators to perform actions on the table itself.

If you data does not need to be updated in realtime or you just want to display some, consider FetchXML as it is executed on the server.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.