Do we have any API for creating a SQL Dataflow in DOMO through python?

Bhargavi
Bhargavi Member
in SQL DataFlows

I am working on SQL transformations within Domo and have a requirement to create a SQL dataflow programmatically from a code engine using a Python script via the API. Does Domo provide any API support for creating dataflows?

Answers

  • GrantSmith
    GrantSmith Coach

    The supported pydomo package doesn't have a way to do this however you can monitor the network traffic when saving or creating a new SQL dataflow to get an idea of the API endpoints you can call with a package like requests to call these endpoints. You'll need to make sure you have a developer token and pass it along as a the X-DOMO-Developer header.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ArborRose
    ArborRose Coach

    @Bhargavi - Although I haven't done this specific thing myself, I believe you can write code in Python using Jupyter Workspaces in Domo, and make SQL calls. Consider the following…

    import domojupyter as domo
    
import pandas as pd
    
import pandasql as ps

    
# Replace 'dataset_id' with your actual dataset ID from Domo
    
dataset_id = 'YOUR_DATASET_ID'
    
df = domo.read_dataframe(dataset_id)

    
# Example SQL query
    
query = """
    
SELECT column1, column2
    
FROM df
    
WHERE column3 > 100
    
"""
    
result = ps.sqldf(query, locals())
    
print(result)

    This would use a dataset from Domo and handle it like a SQL table using pandasql.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories