Hi,
I'm trying to get information out of HubSpot in to Power Automate. I've got the webhook working and it is passing the details but i'm having a load of issues with the JSON scheme, it seems to be arraying all the results where i only need to get the value of the items. i've tried amending the JSON scheme but then get errors, and also the HTTP input ignores the scheme. Below is the results i get:
Below is the output for the Parse JSON
{
"portalId": 2503545,
"objectType": "DEAL",
"objectTypeId": "0-3",
"objectId": 2380071715,
"properties": {
"hs_closed_amount_in_home_currency": {
"versions": [
{
"name": "hs_closed_amount_in_home_currency",
"value": "0",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "0",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceId": null
},
"dealname": {
"versions": [
{
"name": "dealname",
"value": "Test Deal",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Test Deal",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"num_associated_contacts": {
"versions": [
{
"name": "num_associated_contacts",
"value": "2",
"timestamp": 1594129818605,
"sourceId": "RollupProperties",
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "2",
"timestamp": 1594129818605,
"source": "CALCULATED",
"sourceId": "RollupProperties"
},
"description": {
"versions": [
{
"name": "description",
"value": "Deal Description",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Deal Description",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"createdate": {
"versions": [
{
"name": "createdate",
"value": "1594049935262",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "1594049935262",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_is_closed": {
"versions": [
{
"name": "hs_is_closed",
"value": "false",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "false",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceId": null
},
"amount_in_home_currency": {
"versions": [
{
"name": "amount_in_home_currency",
"value": "97",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "97",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceId": null
},
"hs_deal_stage_probability": {
"versions": [
{
"name": "hs_deal_stage_probability",
"value": "0.200000000000000011102230246251565404236316680908203125",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "0.200000000000000011102230246251565404236316680908203125",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceId": null
},
"days_to_close": {
"versions": [
{
"name": "days_to_close",
"value": "25",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "25",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceId": null
},
"estimated_gp_value": {
"versions": [
{
"name": "estimated_gp_value",
"value": "60",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "60",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_manual_forecast_category": {
"versions": [
{
"name": "hs_manual_forecast_category",
"value": "PIPELINE",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "PIPELINE",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hubspot_owner_id": {
"versions": [
{
"name": "hubspot_owner_id",
"value": "48602422",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "48602422",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_closed_amount": {
"versions": [
{
"name": "hs_closed_amount",
"value": "0",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "0",
"timestamp": 1594049949981,
"source": "CALCULATED",
"sourceId": null
},
"event_type": {
"versions": [
{
"name": "event_type",
"value": "Conference",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Conference",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_analytics_source": {
"versions": [
{
"name": "hs_analytics_source",
"value": "OFFLINE",
"timestamp": 1594113863495,
"sourceId": "deal sync triggered by vid=10026151",
"source": "DEALS",
"sourceVid": []
}
],
"value": "OFFLINE",
"timestamp": 1594113863495,
"source": "DEALS",
"sourceId": "deal sync triggered by vid=10026151"
},
"project_owner": {
"versions": [
{
"name": "project_owner",
"value": "Kate Olive",
"timestamp": 1594103460972,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Kate Olive",
"timestamp": 1594103460972,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"next_step": {
"versions": [
{
"name": "next_step",
"value": "Next Step",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Next Step",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"actual_gp_": {
"versions": [
{
"name": "actual_gp_",
"value": "98",
"timestamp": 1594103842060,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "98",
"timestamp": 1594103842060,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"push_to_procim": {
"versions": [
{
"name": "push_to_procim",
"value": "true",
"timestamp": 1594102371713,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "true",
"timestamp": 1594102371713,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_created_by_user_id": {
"versions": [
{
"name": "hs_created_by_user_id",
"value": "11098766",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "11098766",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
},
"hs_createdate": {
"versions": [
{
"name": "hs_createdate",
"value": "1594049949981",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "1594049949981",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
},
"event_date": {
"versions": [
{
"name": "event_date",
"value": "1594166400000",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "1594166400000",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_projected_amount": {
"versions": [
{
"name": "hs_projected_amount",
"value": "19.400000000000001076916333886401844210922718048095703125",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "19.400000000000001076916333886401844210922718048095703125",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceId": null
},
"hs_all_owner_ids": {
"versions": [
{
"name": "hs_all_owner_ids",
"value": "48602422",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "48602422",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
},
"hs_projected_amount_in_home_currency": {
"versions": [
{
"name": "hs_projected_amount_in_home_currency",
"value": "19.400000000000001076916333886401844210922718048095703125",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "19.400000000000001076916333886401844210922718048095703125",
"timestamp": 1594103842060,
"source": "CALCULATED",
"sourceId": null
},
"estimated_gp_": {
"versions": [
{
"name": "estimated_gp_",
"value": "60",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "60",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"dealtype": {
"versions": [
{
"name": "dealtype",
"value": "newbusiness",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "newbusiness",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"amount": {
"versions": [
{
"name": "amount",
"value": "97",
"timestamp": 1594103842060,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "97",
"timestamp": 1594103842060,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"closedate": {
"versions": [
{
"name": "closedate",
"value": "1596209935262",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "1596209935262",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"opportunity_source": {
"versions": [
{
"name": "opportunity_source",
"value": "Email",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "Email",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"business_area": {
"versions": [
{
"name": "business_area",
"value": "212 Studio Venue",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "212 Studio Venue",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_user_ids_of_all_owners": {
"versions": [
{
"name": "hs_user_ids_of_all_owners",
"value": "11098766",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "11098766",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
},
"pipeline": {
"versions": [
{
"name": "pipeline",
"value": "default",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "default",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"actual_gp_value": {
"versions": [
{
"name": "actual_gp_value",
"value": "100",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "100",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"project_account_director": {
"versions": [
{
"name": "project_account_director",
"value": "ProjectAccountDirector",
"timestamp": 1594103460972,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "ProjectAccountDirector",
"timestamp": 1594103460972,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_lastmodifieddate": {
"versions": [
{
"name": "hs_lastmodifieddate",
"value": "1594129820209",
"timestamp": 1594129820209,
"source": "CALCULATED",
"sourceVid": []
}
],
"value": "1594129820209",
"timestamp": 1594129820209,
"source": "CALCULATED",
"sourceId": null
},
"hubspot_owner_assigneddate": {
"versions": [
{
"name": "hubspot_owner_assigneddate",
"value": "1594049949981",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "1594049949981",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"dealstage": {
"versions": [
{
"name": "dealstage",
"value": "appointmentscheduled",
"timestamp": 1594049949981,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "appointmentscheduled",
"timestamp": 1594049949981,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_object_id": {
"versions": [
{
"name": "hs_object_id",
"value": "2380071715",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "2380071715",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
},
"hs_analytics_source_data_2": {
"versions": [
{
"name": "hs_analytics_source_data_2",
"value": "CRM_UI",
"timestamp": 1594113863495,
"sourceId": "deal sync triggered by vid=10026151",
"source": "DEALS",
"sourceVid": []
}
],
"value": "CRM_UI",
"timestamp": 1594113863495,
"source": "DEALS",
"sourceId": "deal sync triggered by vid=10026151"
},
"pm_assigned": {
"versions": [
{
"name": "pm_assigned",
"value": "MJ",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "MJ",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_analytics_source_data_1": {
"versions": [
{
"name": "hs_analytics_source_data_1",
"value": "CONTACTS",
"timestamp": 1594113863495,
"sourceId": "deal sync triggered by vid=10026151",
"source": "DEALS",
"sourceVid": []
}
],
"value": "CONTACTS",
"timestamp": 1594113863495,
"source": "DEALS",
"sourceId": "deal sync triggered by vid=10026151"
},
"final_actual_revenue": {
"versions": [
{
"name": "final_actual_revenue",
"value": "10",
"timestamp": 1594103391017,
"sourceId": "andy.melsom@drpgroup.com",
"source": "CRM_UI",
"sourceVid": []
}
],
"value": "10",
"timestamp": 1594103391017,
"source": "CRM_UI",
"sourceId": "andy.melsom@drpgroup.com"
},
"hs_updated_by_user_id": {
"versions": [
{
"name": "hs_updated_by_user_id",
"value": "11098766",
"timestamp": 1594049949981,
"sourceId": "CRM_UI",
"source": "CONTACTS",
"sourceVid": []
}
],
"value": "11098766",
"timestamp": 1594049949981,
"source": "CONTACTS",
"sourceId": "CRM_UI"
}
},
"version": 17,
"secondaryIdentifier": null,
"isDeleted": false
}
This is then what the
As you can see it array's all the results I've tried changing the array to a string and removing the items i don't need i only need to capture the value result from all the data sent, but I get issues with the scheme, this is probably user based as i'm not 100% with JSON coding.
Any help would be really great!
