Azure / Azure/data-api-builder

Failure of read database policy for related entity in multiple create for N:1 and 1:1 relationships returns error

Open
#2,196 1 comment 0 reactions 0 assignees View on GitHub
bug Multiple mutations
Dominant language
C#
Stars
1.5k
Forks
370
Avg merge
3d 22h
Merged PRs (30d)
9

Description

For N:1 and 1:1 relationships where the read policy prohibits returning the result of the insertion in the related entity, we get an exception:

![image](https://github.com/Azure/data-api-builder/assets/34566234/80a05ca2-f7da-4701-ba58-5e10341806e1)

In the config, the policy for read operation is defined as:

![image](https://github.com/Azure/data-api-builder/assets/34566234/5c395e1e-d4bf-446a-9739-47e59a650903)

Contributor guide

Open the contributing guide

Research direction

Start by reproducing a multiple-create operation involving N:1 or 1:1 relationships with a restrictive read policy on the related entity. Trace how the insertion result is handled when the policy prevents returning it; done means the operation no longer raises the reported exception and the read policy remains enforced.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
api, authorization, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.