Unanswered

Web API Portal syntax error because table permission settings

(0) Share

Report

Posted on by 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!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Saud Ali 812 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Alkahfi on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Lucas001 2,575 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No