In Azure Datafactory i’m trying to read an excel from sharepoint.
I need to know the number of sheet to read from the rightmost sheet (highest index), apparently you can’t use the “Get Metadata” activity since it doesn’t support http datasets

I’m creating a pipeline where I have ton of files that I have to loop through, log and load to snowflake

I am new to Azure Data Factory, Trying to create some derived columns for a data transformations. In that I want to create a column name as follows 'test:by:uat:trans:schemas:ext:value:2.0:Account' but how it’s coming in after the transformation (json) is '0:Account'.

I have an ADF pipeline with a REST API call that is supposed to return data in chunks, with a maximum of 100 records per page.

How to sort data in lookup in azure data factory – pipeline with timestamp?