可以获取功率自动滤清器阵列以呈现出不同的结果
我有2个阵列。其中一个阵列是Office 365联系人的列表。另一个数组包含来自API的客户列表。我在联系人阵列上使用了精选语句，因此它的格式与我的客户数组的格式相同。当我创建以下过滤器数组时，我再也没有找到要寻找的独特物品。
这是我使用PEEK代码时的代码。
{
"inputs": {
"from": "@variables('Customers Arrary')",
"where": "@not(contains(variables('Contacts Array'), item()))"
},
"metadata": {
"operationMetadataId": "9ab3697e-6f5c-41b4-b94e-41641ce3dacf"
}
}
我要寻找的结果是找到客户数组中与联系人数组中任何内容的所有项目。唯一标识符是电子邮件地址和手机号码。
任何帮助都非常感谢！提前致谢！
I've got 2 Arrays. One of the Arrays is a list of Office 365 Contacts. The other Array contains a list of Customers from an API. I've used a Select statement on my Contacts Array, so that it is in the same format as my Customer Array. When I create the following Filter Array, I never get the distinct item I'm looking for.
Here is the Code when I use Peek Code.
{
"inputs": {
"from": "@variables('Customers Arrary')",
"where": "@not(contains(variables('Contacts Array'), item()))"
},
"metadata": {
"operationMetadataId": "9ab3697e-6f5c-41b4-b94e-41641ce3dacf"
}
}
The result I'm looking for is to find all the items in the Customer Array that don't match to anything in the Contacts Array. The unique identifiers are email address and mobile number.
Any help is much appreciated! Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我终于让这个工作了。为了使此工作起作用，数据集必须匹配。例如，如果您将两个数据集与电子邮件地址进行比较，那是您唯一可以拥有的数据，最好没有任何零值。这是我创建的示例过滤器。两个阵列的JSON仅包含电子邮件地址值。
因此，请确保并删除两个数据集中未出现的任何数据。我还将删除任何包含无效值的项目。
I finally got this to work. In order for this to work, the data sets have to match. For example, if you are comparing two data sets against an email address, that's the only data you can have, and you better not have any null values. Here is an example filter I created. The JSON from the two arrays only contains email address values.
So, make sure and remove any data that does not appear in both data sets. I would also remove any items that contain null values.