python - 手动生成的 JSON 可以工作，但通过 json.dumps 创建的 JSON 不起作用，即使输出看起来完全相同

Question

我正在通过 Python 库使用 Marketo API marketo-rest-python 。我可以创建潜在客户并通过以下基本代码更新它们:

leads = [{"email":"<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="f79d9892b7928f969a879b92d994989a" rel="noreferrer noopener nofollow">[email protected]</a>","firstName":"Joe"},{"email":"<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="c1aba8adad81a4b9a0acb1ada4efa2aeac" rel="noreferrer noopener nofollow">[email protected]</a>","firstName":"Jill"}]
lead = mc.execute(method='create_update_leads', leads=leads, action='createOnly', lookupField='email', 
                asyncProcessing='false', partitionName='Default')

当我以编程方式创建此“引导”JSON 对象时

leads = []

lead = {}
lead['email'] = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="a3c9ccc6e3c6dbc2ced3cfc68dc0ccce" rel="noreferrer noopener nofollow">[email protected]</a>"
lead['firstName'] = "Joe"
leads.append(lead)

lead = {}
lead['email'] = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="9ff5f6f3f3dffae7fef2eff3fab1fcf0f2" rel="noreferrer noopener nofollow">[email protected]</a>"
lead['firstName'] = "Jill"
leads.append(lead)

json_leads = json.dumps(leads, separators=(',', ':'))

print(json_leads)

然后，Microsoft Azure Databricks 中的输出完全相同，但 Marketo 系统返回一个 609-> Invalid JSON。

我的输出看起来像

[{"email":"<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="92f8fdf7d2f7eaf3ffe2fef7bcf1fdff" rel="noreferrer noopener nofollow">[email protected]</a>","firstName":"Joe"},{"email":"<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="b7dddedbdbf7d2cfd6dac7dbd299d4d8da" rel="noreferrer noopener nofollow">[email protected]</a>","firstName":"Jill"}]

与示例中的完全相同。当我使用示例 JSON 代码行时，它可以工作，但我自己生成的 JSOn 不起作用。

有人知道这是什么吗？我在 Microsoft Azure Databricks 中使用 Python。

Answer 1

我相信你不需要调用json.dumps，只需这样做

leads = []

lead = {}
lead['email'] = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="e882878da88d90898598848dc68b8785" rel="noreferrer noopener nofollow">[email protected]</a>"
lead['firstName'] = "Joe"
leads.append(lead)

lead = {}
lead['email'] = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="bbd1d2d7d7fbdec3dad6cbd7de95d8d4d6" rel="noreferrer noopener nofollow">[email protected]</a>"
lead['firstName'] = "Jill"
leads.append(lead)

lead = mc.execute(method='create_update_leads', leads=leads, action='createOnly', 
lookupField='email', asyncProcessing='false', partitionName='Default')