Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
9 months ago
Solved

Does anyone knows how to run a http call in a notebook

I am reading a MS documentation, it says one can refresh sql endpoint meta data via a http call:

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints/{sqlEndpointId}/refreshMetadata

https://learn.microsoft.com/en-us/rest/api/fabric/sqlendpoint/items/refresh-sql-endpoint-metadata?tabs=HTTP

How can I run a http call in notebook? Is it complicated?

 

data engineering
  • OnurOz's avatar
    OnurOz
    9 months ago

    Hi Jeanxyz,

     

    You can run HTTP calls directly from a notebook in Microsoft Fabric using Python, and it's straightforward if you use the popular requests library. This approach works in both Spark and non-Spark Python environments.

     

    import requests

url = "https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints/{sqlEndpointId}/refreshMetadata"
headers = {
    "Authorization": "Bearer YOUR_ACCESS_TOKEN"
}

response = requests.post(url, headers=headers)
print(response.status_code)
print(response.text)

     

    Replace {workspaceId}, {sqlEndpointId}, and YOUR_ACCESS_TOKEN with your actual values. You must provide a valid Azure AD access token, this usually involves authentication, which can be handled via Azure Identity, MSAL, or other SDKs that you may already use for automation.

     

    Hope that helps

    Onur

    😊If this post helped you, feel free to give it some Kudos! 👍

    ✅And if it answered your question, please mark it as the accepted solution.

3 Replies

  • OnurOz's avatar
    OnurOz
    Resolver III
    9 months ago

    Hi Jeanxyz,

     

    You can run HTTP calls directly from a notebook in Microsoft Fabric using Python, and it's straightforward if you use the popular requests library. This approach works in both Spark and non-Spark Python environments.

     

    import requests

url = "https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints/{sqlEndpointId}/refreshMetadata"
headers = {
    "Authorization": "Bearer YOUR_ACCESS_TOKEN"
}

response = requests.post(url, headers=headers)
print(response.status_code)
print(response.text)

     

    Replace {workspaceId}, {sqlEndpointId}, and YOUR_ACCESS_TOKEN with your actual values. You must provide a valid Azure AD access token, this usually involves authentication, which can be handled via Azure Identity, MSAL, or other SDKs that you may already use for automation.

     

    Hope that helps

    Onur

    😊If this post helped you, feel free to give it some Kudos! 👍

    ✅And if it answered your question, please mark it as the accepted solution.

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    9 months ago

    Hi Jeanxyz 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank OnurOz   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

    I hope the shared details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

     

     

    Best Regards, 
    Community Support Team.

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    9 months ago

    Hi Jeanxyz 

    We would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.

    Thank you.