Mapping data flow in synapse missing attributes values when reading a REST data set

Question

Hi everyone,

this is really weird, I am reading AAD groups using the graph API from a mapping data flow using a REST dataset:

The projection is as expected:

The "renewedDateTime" attribute sometimes has values and sometimes is completely empty in the data preview:

When values are available (I don't know how is that possible), they disappear in the flatten transformation.

Any ideas what could be wrong?

The examples in the documentation cover only string attributes.

Answer 1

Hello,@Paul Hernandez , the property is only updated via the renew service action.
Here is the documentation for reference: https://learn.microsoft.com/en-us/graph/api/resources/group?view=graph-rest-1.0#properties

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.