Hello Harish,
The challenge here is to split the string that comes from the response, and you can do it by using the StringSplit java action from the CommunityCommons module of Mendix.
After getting the response, you need to use this Java action and with regex give the certain pattern for the string split. In the link below is the documentation where you can search for StringSplit.
https://docs.mendix.com/appstore/modules/community-commons-function-library/
✅ Example
Suppose you have a string:
"apple;banana orange,grape"
And you want to split by comma, semicolon, or space.
Microflow Example:
InputString = "apple;banana orange,grape"
StringSplit
Java action from Community Commons:
$InputString
[,; ]
apple
, banana
, orange
, grape
Let me know in case you need more info!
Kind regards!
Fjordi