Hi I have 3 columns I have to create JSON So I can push it into an API, Below is the example
Input
Vender | Fruits | State |
Jhon | Apple | NYC |
Rick | Mango | TKY |
Matt | Banana | LND |
Output:
Vender | Fruits | State | JSON |
Jhon | Apple | NYC | { "Vender": "Jhon", "Fruits": "Apple", "State":"NYC" }
|
Rick | Mango | TKY | { "Vender": "Rick", "Fruits": "Mango", "State":"TKY" } |
Matt | Banana | LND | { "Vender": "Matt", "Fruits": "Banana", "State":"LND" } |
Let me know if there is any other to construct JSON
Solved! Go to Solution.
Hi @Sshasnk I mocked up a workflow that produces the output you describe. Let me know what you think?
@JosephSerpis I also need the field names vender fruit, and State. Your solution is giving only JSON column
Hi @Sshasnk I amended the workflow and attached the original fields back on.