Hello @Priyanka_Bhalere,
sorry for the late reply.
In order to capture values from the Weather entity, you must add the fields with the information you are interested in extracting, in the Weather entity. So, you should follow the steps below.
The following entities are required:
[[ WeatherInfo ]] - with following fields: id, main, description, icon (or only the required fields)
[[ Weather ]] - with following fields:
- Lon
- Lat
- WeatherInfo - EntityList, refers entity [[WeatherInfo]]
For coordinate capture, the mapping will done this way:
coord.lon => [[Weather]].Lon
coord.lat => [[Weather]].Lat
Mapping in the section " ResponseMainEntity " should be like:
Connector field name = weather (as in the answer in JSON)
Druid Entity Field Name = [[Weather]].WeatherInfo
Druid Child Mapping Code = be filled with “WeatherInfo”
Press the button " AddNewChildMapping " and enter the newly createad section at the top, to rename the section in “WeatherInfo”. Will be completed the field ResponseDruidEntityName with the value [[WeatherInfo]]
Mapping in section “WeatherInfo”:
Connector field name = id
Druid Entity Field Name = [[WeatherInfo]].Id
Connector field name = main
Druid Entity Field Name = [[WeatherInfo]].main
Connector field name = description
Druid Entity Field Name = [[WeatherInfo]].description
The final result will be in [[Weather]].WeatherInfo[0].main == assuming you only have one record in the collection
Below I send you an example of an answer from the API, wich will guide you in the configurations you have to do
{
“odata.metadata”: “odata.metadata”,
“value”: [
{
“odata.type”: “SP.Data.Workflow_x0020_TasksListItem”,
“odata.id”: “808817de-9f2a-44a6-bf75-4358cb58a5c2”,
“odata.etag”: “"1"”,
“odata.editLink”: “Web/Lists(guid’d20fc45f-aaec-4b7e-a64b-9284daec52ca’)/Items(100197)”,
“AssignedTo@odata.navigationLinkUrl”: “Web/Lists(guid’d20fc45f-aaec-4b7e-a64b-9284daec52ca’)/Items(100197)/AssignedTo”,
“AssignedTo”: {
“odata.type”: “SP.Data.UserInfoItem”,
“odata.id”: “c549b320-9f7a-4457-a863-0664e5973df6”,
“Title”: “Title”
},
“Id”: 100197,
“Title”: “desk”,
“Status”: “Not Started”,
“WorkflowLink”: {
“Description”: “Description”,
“Url”: “http://url/Lists/ExpenseRequest/DispForm.aspx?ID=1”
},
“WorkflowOutcome”: “Pending”,
“WorkflowName”: “Expense Request Approval”,
“WorkflowListId”: “ca77c5b2-265c-4b44-b592-dcdb215124ed”,
“WorkflowItemId”: 23221,
“MultiOutcomeTaskInfo”: “MultiOutcomeTaskInfo”,
“GUID”: “77db48e4-1d26-4ddc-b9c5-7a7a699c2c64”,
“WorkflowInstanceID”: “a7697636-2879-4690-98ef-439ff893978f”,
“ID”: 100197,
“Created”: “2020-11-06T10:46:55Z”
},
{
“odata.type”: “SP.Data.Workflow_x0020_TasksListItem”,
“odata.id”: “24daa2c9-1aad-4966-b07e-a8495853b33b”,
“odata.etag”: “"1"”,
“odata.editLink”: “Web/Lists(guid’d20fc45f-aaec-4b7e-a64b-9284daec52ca’)/Items(99987)”,
“AssignedTo@odata.navigationLinkUrl”: “Web/Lists(guid’d20fc45f-aaec-4b7e-a64b-9284daec52ca’)/Items(99987)/AssignedTo”,
“AssignedTo”: {
“odata.type”: “SP.Data.UserInfoItem”,
“odata.id”: “d6231e21-969f-4c13-a530-faf2bf2f3790”,
“Title”: “Title”
},
“Id”: 99987,
“Title”: “work mobile phone”,
“Status”: “Not Started”,
“WorkflowLink”: {
“Description”: “work mobile phone”,
“Url”: “http://url/Lists/ExpenseRequest/DispForm.aspx?ID=2”
},
“WorkflowOutcome”: “Pending”,
“WorkflowName”: “Expense Request Approval”,
“WorkflowListId”: “ca77c5b2-265c-4b44-b592-dcdb215124ed”,
“WorkflowItemId”: 23218,
“MultiOutcomeTaskInfo”: “MultiOutcomeTaskInfo”,
“GUID”: “35b8393c-ff0c-434e-bc3d-d1cf49805925”,
“WorkflowInstanceID”: “53bfed4e-4a7d-4a88-9b01-2185054472d5”,
“ID”: 99987,
“Created”: “2020-11-05T08:27:11Z”
}
]
}
Which maps acording to the images below

