Référence API
API publique
- API publique (import racine)
- I/O Lakehouse et Warehouse
- Qualité des données et pipelines Silver
- Dimensions (calendrier et géographie)
- Couche préparée (prepared)
- Transformations DataFrame
filter_column_by_values()drop_rows_over_empty_percent()merge_dataframes()remove_columns()rename_columns_normalized()rename_columns_pq_serial_to_dates()rename_columns_pq_serial_to_mois_annee()rename_columns_month_year_block_labels()month_start_from_ca_monthly_col()resolve_dataframe_column()wide_value_columns()dataframe_unpivot_wide_month_suffix()dataframe_last_nonnull_wide_month_from_long()dataframe_pivot_category_wide_month_from_long()transform_wide_month_suffix()year_from_fr_text()month_from_fr_text()with_year_month_from_fr_text()norm_text()empty_or_null()coalesce_dim()
- Power Query (API publique)
- Excel (API publique)
- Intégration IFS Cloud
- Inférence IA (agent LangChain)
Implémentation
- Noyau applicatif (core)
log()build_lakehouse_read_path_candidates()build_lakehouse_write_path()get_lakehouse_abfs_path()get_warehouse_jdbc_url()configure_parquet_datetime_rebase()get_spark()build_lakehouse_read_path_candidates()build_lakehouse_write_path()get_lakehouse_abfs_path()get_spark()get_warehouse_jdbc_url()log()
- Dimensions (calendrier et géographie)
- I/O Lakehouse et Warehouse
filter_pipeline_discovered_tables()get_fs_entry_name()list_lakehouse_tables()list_lakehouse_tables_for_pipeline()delete_all_lakehouse_tables()delete_lakehouse()lakehouse_table_exists()merge_lakehouse()read_lakehouse()read_lakehouses()resolve_lakehouse_read_candidate()write_lakehouse()write_lakehouses()read_warehouse()write_warehouse()delete_all_lakehouse_tables()delete_lakehouse()filter_pipeline_discovered_tables()lakehouse_table_exists()list_lakehouse_tables()list_lakehouse_tables_for_pipeline()merge_lakehouse()read_lakehouse()read_lakehouses()read_warehouse()resolve_lakehouse_read_candidate()write_lakehouse()write_lakehouses()write_warehouse()
- Pipelines — configuration des jobs
- Power Query API
DateInt64ListNumberOrderPercentageTableTable.AddColumn()Table.Buffer()Table.Combine()Table.Distinct()Table.DuplicateColumn()Table.FillDown()Table.FillUp()Table.FirstN()Table.Group()Table.Join()Table.LastN()Table.NestedJoin()Table.Pivot()Table.Range()Table.RemoveColumns()Table.RenameColumns()Table.ReorderColumns()Table.ReplaceErrorValues()Table.ReplaceValue()Table.SelectColumns()Table.SelectRows()Table.Skip()Table.Sort()Table.SplitColumn()Table.TransformColumnTypes()Table.TransformColumns()Table.Unpivot()
Texttype- Table.*
TableTable.AddColumn()Table.Buffer()Table.Combine()Table.Distinct()Table.DuplicateColumn()Table.FillDown()Table.FillUp()Table.FirstN()Table.Group()Table.Join()Table.LastN()Table.NestedJoin()Table.Pivot()Table.Range()Table.RemoveColumns()Table.RenameColumns()Table.ReorderColumns()Table.ReplaceErrorValues()Table.ReplaceValue()Table.SelectColumns()Table.SelectRows()Table.Skip()Table.Sort()Table.SplitColumn()Table.TransformColumnTypes()Table.TransformColumns()Table.Unpivot()
- Text.*
- Date.*
- Number.*
- List.*
- Excel API
- Couche préparée (prepared)
generate_prepared_aggregations()prepare_and_write_all_tables()prepare_and_write_data()resolve_columns()snapshot_source_schema()publish_semantic_model()transform_to_prepared()write_prepared_table()generate_prepared_aggregations()make_business_ready()prepare_and_write_all_tables()prepare_and_write_data()publish_semantic_model()resolve_columns()snapshot_source_schema()transform_to_prepared()write_prepared_table()
- Qualité des données et pipelines Silver
- Transformations DataFrame
ParamResolverbuild_tcd()cast_columns()coalesce_dim()dataframe_last_nonnull_wide_month_from_long()dataframe_pivot_category_wide_month_from_long()dataframe_unpivot_wide_month_suffix()drop_rows_over_empty_percent()empty_or_null()filter_column_by_values()merge_dataframes()metric_value_for_class()month_from_fr_text()month_start_from_ca_monthly_col()norm_text()remove_columns()rename_columns_month_year_block_labels()rename_columns_normalized()rename_columns_pq_serial_to_dates()rename_columns_pq_serial_to_mois_annee()resolve_dataframe_column()transform_wide_month_suffix()wide_value_columns()with_year_month_from_fr_text()year_from_fr_text()
- Intégration IFS Cloud