Extract all reocurring key from a JSON array without using a for each loop

Question

Extract all reocurring key from a JSON array without using a for each loop

Sumit Gaur 260

Hi,

is there a way to basically get all the reoccurring key value from the JSON array without running a for each loop in the logic app standard. for e.g., if i am receiving data like below how can i get value of all the occurrences of message with some query or any other way without going through the loop.

[
    {
        "message": "message 1"
    },
    {
        "message": "message 2"
    }
]

Dillon Silzer 57,831 Reputation points Volunteer Moderator

2023-08-25T15:23:10.58+00:00

As far as I know you cannot use a query on a JSON array at this point in time. However I did query ChatGPT to see if there were any other solutions:

However, Logic Apps do offer a variety of actions and conditions that can help simplify your workflow and potentially make your implementation more efficient, depending on your use case. For instance:

Select Action: The "Select" action allows you to project a subset of properties from an array of objects. While it doesn't eliminate the need for looping, it can help you extract specific properties from each object without having to manually iterate over them in a loop.

Filter Action: The "Filter" action can be used to narrow down the objects in the array that match certain criteria. This can help reduce the number of objects you need to process in your logic app.

Compose Action: If you want to aggregate the values of a specific property across all objects in the array, you can use the "Compose" action along with functions like join() or union() to achieve this without explicitly looping.

If this is helpful please accept answer.
VenkateshDodda-MSFT 25,111 Reputation points Microsoft Employee Moderator

2023-08-29T04:50:50.7266667+00:00

Hello @Sumit Gaur ,

I hope the answer helps. Please let me know if you have any further queries.

Please accept as Yes if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

Accepted answer

2 additional answers

Your answer

Dillon Silzer 57,831 Reputation points Volunteer Moderator

2023-08-25T15:23:10.58+00:00

As far as I know you cannot use a query on a JSON array at this point in time. However I did query ChatGPT to see if there were any other solutions:

However, Logic Apps do offer a variety of actions and conditions that can help simplify your workflow and potentially make your implementation more efficient, depending on your use case. For instance:

Select Action: The "Select" action allows you to project a subset of properties from an array of objects. While it doesn't eliminate the need for looping, it can help you extract specific properties from each object without having to manually iterate over them in a loop.

Filter Action: The "Filter" action can be used to narrow down the objects in the array that match certain criteria. This can help reduce the number of objects you need to process in your logic app.

Compose Action: If you want to aggregate the values of a specific property across all objects in the array, you can use the "Compose" action along with functions like join() or union() to achieve this without explicitly looping.

If this is helpful please accept answer.
VenkateshDodda-MSFT 25,111 Reputation points Microsoft Employee Moderator

2023-08-29T04:50:50.7266667+00:00

Hello @Sumit Gaur ,

I hope the answer helps. Please let me know if you have any further queries.

Please accept as Yes if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

Answer 1

VenkateshDodda-MSFT 25,111 Microsoft Employee Moderator

@Sumit Gaur Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

As I have understood that you want to pull the message key value from the JSON array without using foreach loop in your workflow.

To achieve this, you can either use execute Java script code using Inline action or by using liquid templates in your workflow. You can refer to this documentation for more information inline code and liquid templates.

Feel free to reach back to me if you have any further questions on this.

Sumit Gaur 260 Reputation points

2023-08-29T11:13:18.1733333+00:00

I finally have it working out by using create a csv table action to get all the values and then depending on the scenario it can be made as an string array or all can be joined together separated by a comma.
VenkateshDodda-MSFT 25,111 Reputation points Microsoft Employee Moderator

2023-08-29T12:04:17.89+00:00

@Sumit Gaur Thanks for sharing the solution for the benefit of community and Glad to know that your problem has been solved.

Please accept as Yes if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

Extract all reocurring key from a JSON array without using a for each loop

2 additional answers

Your answer