Can't use create_merge_query endpoint, I get the following error "Object of type MergeQuerySourceQuery is not JSON serializable"

[felschoen]

Hello - we want to update some merged results on our instance using Looker SDK and Python. At the moment we are stuck to create a new merged_result_id which we need to update dashboards.

Everything works fine when I use Looker API Explorer in Looker, but when I then run the code (provided by the Looker API Explorer), I get the following Error: TypeError: Object of type MergeQuerySourceQuery is not JSON serializable. Looker SDK version is 24.18.1, so the latest.

I was also already in contact with Looker Support, but they could not help me.

Here is the code I am trying to run:

from looker_sdk.sdk.api40 import models as mdls

response = sdk.create_merge_query(
    body=mdls.WriteMergeQuery(
        dynamic_fields="[]",
        source_queries=[
            mdls.MergeQuerySourceQuery(
                name="Order Items",
                query_id="1234",
                query_slug="ahbgoiugbEAF1234"
            ),
            mdls.MergeQuerySourceQuery(
                merge_fields=[
                    mdls.MergeFields(
                        field_name="orders.paid_week",
                        source_field_name="orders.paid_week"
                    )
                ],
                name="Order Items 2",
                query_id="5678",
                query_slug="ah2b123123goiugbEAF1234"
            )
        ],
        total=False,
        vis_config={}
    ))
    

[felschoen]

I found what needs to be changed:

In looker_sdk/rtl/serialize.py in the function called serialize, I changed the return from
json.dumps(data.encode("utf-8") to
json.dumps(data,default=lambda o: o.__dict__).encode("utf-8").

I did not test it if it breaks other stuff, but at least everything works for me now :)

[drstrangelooker]

Thanks for the solution. We will do some testing with it.