Creating json variable with Airflow web API

Question

I'm trying to create variable with json value in Airflow using web api.

My script:

curl -X POST "${AIRFLOW_URL}/api/v1/variables" \
        -H "Content-Type: application/json" \
        --user "${AIRFLOW_USERNAME}:${AIRFLOW_PASSWORD}" \
        -d '{"key": "my_json_var", "value": {"key1":"val1","key2":"123"}}'

But it doesn't work. I get 400 status:

{
  "detail": "{'key1': 'val1', 'key2': '123'} is not of type 'string' - 'value'",
  "status": 400,
  "title": "Bad Request",
  "type": "https://airflow.apache.org/docs/apache-airflow/2.7.1/stable-rest-api-ref.html#section/Errors/BadRequest"
}

What am I doing wrong?

ps. I tried using python with requests and got the same result. I think the problem is in the airflow web api. Perhaps their methods don't support adding json variables

Pankaj Singh · Accepted Answer · 2023-12-11 17:10:55Z

1

No problem with airflow API it accepts a variable value as a string as described in the documentation you can check https://airflow.apache.org/docs/apache-airflow/stable/stable-rest-api-ref.html#operation/post_variables

You should change the variable value to a string and it should work

curl -X POST ${AIRFLOW_URL}/api/v1/variables \
        -H "Content-Type: application/json" \
        --user "${AIRFLOW_USERNAME}:${AIRFLOW_PASSWORD}" \
        -d '{"key": "my_json_var", "value": "{\"key1\":\"val1\",\"key2\":\"123\"}"}'

answered Dec 11, 2023 at 17:10

Pankaj Singh

1,2182 gold badges12 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Viktorov Ivan Over a year ago

Thank you! When I was composing the script, I made a mistake with escaping quotes.

Collectives™ on Stack Overflow

Creating json variable with Airflow web API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related