Salesforce，我在CSV文件中有50K记录，其中包含ID列，我想检查是否通过Workbench中的Salesforce中存在记录。我如何查询？
我有50 K记录，带有ID字段。我需要检查此记录是否存在，并在存在时导入到文件中。我如何通过此庞大的计数
从帐户中对Salesforce Workbench进行查询，其中ID（'xxxxx'，'yyyyy'）
我正在使用上述查询，但它需要大量时间，甚至想知道Workbench甚至允许查询这些许多记录。
I have 50 k records with Id field. I need to check whether this records exist or not and import into file if exists . How do I query against salesforce workbench with this huge count
SELECT Id FROM Account WHERE Id IN('XXXXX','YYYYY')
I am using above query but it takes huge time and even wonder even workbench allow query these many records.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SOQL can handle queries up to 100K字符。
它不合适，您将必须将其切成较小的查询。
如果工作台仍然超时 - 您可以尝试使用Bulk API选项并稍后下载CSV（尝试使用较小的查询SAIS
限制100以查看其工作原理）。还是安装数据加载程序？你为什么需要这样做？如果您打算知道哪些需要插入，哪些需要更新 - 有UPSERT操作可以为您提供映射。
还有一个技巧，但听起来有些愚蠢。 “拧紧，更新它们”。仅使用这些ID准备文件，然后将其加载为更新操作。没有其他字段，好像用户点击编辑并保存Withotu更改任何内容，只是最后修改的日期。然后检查IDS SF找不到的错误文件，成功的成功文件（或在SF GO
中，从帐户中选择ID lastModifiedDate = today and lastModifiedby.name ='Ashok'）SOQL can handle queries up to 100K characters.
It won't fit, you will have to cut it up into smaller queries.
If Workbench still timeouts - you could try using the bulk api option and download the CSV later (try with a smaller query say
LIMIT 100to see how it works). Or install Data Loader?Why do you need to do it? If you plan to know which ones need insert, which ones need update - there's upsert operation that will do the mapping for you.
There's one more trick but it sounds bit stupid. "Screw it, update them all". Prepare file with just these Ids and load it as update operation. No other fields, it'll be as if user hit edit and save withotu changing anything, just last modified date. Then examine error file for ids SF couldn't find, success file for successes (or in SF go
SELECT Id FROM Account WHERE LastModifiedDate = TODAY AND LastModifiedBy.Name = 'Ashok')