英文:
LogicApp - Changing JSON
问题
以下是您提供的JSON数据的转换结果：
[
{
"An Id": 123,
"Full Name": "John Doe",
"New Field Added": "A value which is new"
},
{
"An Id": 124,
"Full Name": "James Deen",
"New Field Added": "A new value"
}
]
希望这有助于您解决问题。如果您需要更多帮助，请随时提问。
英文:
I have some JSON like this produced from a step in the LogicApp I am working on.
[
{
"id": 123,
"displayName": "John Doe",
"firstName": "John",
"lastName": "Doe",
"gender": "Male",
"jobTitle": "Customer Service Representative",
"workPhone": "555-555-5555",
"workPhoneExtension": null,
"skypeUsername": "JohnDoe",
"facebook": "JohnDoeFacebook"
},
{
"id": 124,
"displayName": "James Deen",
"firstName": "James",
"lastName": "Deen",
"gender": "Male",
"jobTitle": "Job Title",
"workPhone": "555-555-5555",
"workPhoneExtension": null,
"skypeUsername": "JamesDean",
"facebook": "JamesDeenFacebook"
}
]
I was hoping the use of the SELECT component would allow me to exclude fields and essentially rename fields.
How would I transform the above JSON into the following?
[
{
"An Id": 123,
"Full Name": "John Doe",
"New Field Added", "A value which is new"
},
{
"An Id": 124,
"Full Name": "James Deen",
"New Field Added", "A new value"
}
]
At the moment, I am getting issues with FOREACH components being added. I have also used FOREACH loops and various ways to achieve this change.
Would very much appreciate someone explaining the best way to do this.
For example with a SELECT added with one field mapped I see
When adding another it adds a foreach changes things.
Many thanks in advance
答案1
得分: 0
答案是因为我选择了不正确的"from"值。在字段列表中，我包含了JSON中的每个字段，还包括包含值的数组名称，以及一个'body'项目。
当您选择数组名称，比如employees时，它会出现问题，但如果您使用body项目，它会正常工作。
英文:
The answer is because I was choosing the incorrect from value. In the list of fields I had each field from the JSON, plus the array name holding the values, plus the a 'body' item.
It goes wrong when you select the array name , in this case employees but if you use the body item, it works properly.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论