when i tried to retrieve data from JSON file in the input payload metadata(database Connector) . I am able to find the column names but the data is reflecting . Please suggest me how to add JSON data in the input payload metadata of database connector.
4 answers
You can you use following to retrieve the body of post message:
If Post body is json then use Json to Object transformer activity
For full payload:
# [payload]
For given key element:
# [payload.key_element]
for example:
{
" first_name": "sunil",
" last_name": "singhal"
}
If you want to get last name out of above given message then;
# [payload.last_name]
