Forum Discussion

FurkanSa's avatar
FurkanSa
Frequent Visitor
10 months ago
Solved

Write data to Lakehouse via c# with REST API

Hello Data Fam, We need to write our data directly to a Lakehouse from C# via an API. The API owner needs to implement the write functionality, and we cannot just send a GET request to them. I...
data engineering
Data Pipeline
Lakehouse
Notebook
  • v-karpurapud's avatar
    v-karpurapud
    10 months ago

    Hi FurkanSa 
    Thank you for your question on the Microsoft Fabric Community Forum.

     

    At this time, there is no REST API endpoint available for writing data directly into a Microsoft Fabric Lakehouse table, such as a POST /tables call. The recommended approach is to use the OneLake REST API, which is compatible with Azure Data Lake Storage Gen2. You can upload files (CSV, Parquet, JSON, etc.) to the Lakehouse’s Files or Tables directory by sending authenticated PUT requests from C# after obtaining an Azure AD access token. Once the data is uploaded, you can leverage Fabric services such as Spark, SQL, or Dataflows to transform these files into structured Lakehouse tables (Delta format). This method is fully supported and aligns with Microsoft Fabric’s architecture. For your use case, it is advisable for the API owner to implement write operations using the OneLake REST API with Azure AD authentication, rather than unsupported POST calls to Fabric APIs.

     

    I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

     

    Regards,

    Microsoft Fabric Community Support Team.

v-karpurapud's avatar
v-karpurapud
Community Support
10 months ago

Hi FurkanSa 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.