格子API投资控股公司没有独特的标识符

发布于 2025-02-10 03:51:34 字数 764 浏览 1 评论 0原文

/Investments/Holdings/GET不会返回唯一的标识符。因此，在不擦除所有现有的保存数据的情况下，似乎无法进行本地数据库更新。我缺少什么吗？

Plaid的示例响应：

{
    "account_id": "5d37rd4BdJkq1zZkR8XEI9ovVAn35Ph464637",
    "cost_basis": null,
    "institution_price": 15.24,
    "institution_price_as_of": null,
    "institution_value": 30.48,
    "iso_currency_code": "USD",
    "quantity": 2,
    "security_id": "3mg4qV4JZyckeZnYfgazubEhn8gLKkUeMVpx4",
    "unofficial_currency_code": null
}

请注意，account_id + security_id不是有效的复合键。格子返回每个持有的“批量”，因此可以有多个持有的安全性和帐户，因为它们可能具有不同的成本基础。

如果格子在听，那么在响应中添加唯一的holding_id，这肯定是在格子的末端存储，类似于transaction_id，item_id < /code>，或account_id。

原文

/investments/holdings/get does not return a unique identifier. So it does not seem possible to make local DB updates without wiping all existing holding data. Is there something I'm missing?

Sample response from Plaid:

{
    "account_id": "5d37rd4BdJkq1zZkR8XEI9ovVAn35Ph464637",
    "cost_basis": null,
    "institution_price": 15.24,
    "institution_price_as_of": null,
    "institution_value": 30.48,
    "iso_currency_code": "USD",
    "quantity": 2,
    "security_id": "3mg4qV4JZyckeZnYfgazubEhn8gLKkUeMVpx4",
    "unofficial_currency_code": null
}

Note that account_id + security_id is not a valid compound key. Plaid returns each "lot" of a holding, so there can be multiple holdings for the same security and account, as they would likely have different cost bases.

If Plaid is listening, it would be nice to add a unique holding_id to the response, which is surely being stored on Plaid's end, similar to transaction_id, item_id, or account_id.

分享到QQ

分享到微博