Parsing JSON response from webhook

Anonymous
Not applicable

Parsing JSON response from webhook

I have a JSON response I'm trying to parse that looks something like this:

{
  • count1,
  • type"FeatureCollection",
  • features
     
    [
    •  
      {
      • type"Feature",
      • properties
         
        {
        • umi.geolytics.projection_year_summaries.avghhsze1.53,
        • umi.geolytics.projection_year_expenditures.entertain3002,
        • umi.geolytics.projection_year_housing_stats.medhomval851416,
        • umi.geolytics.projection_year_expenditures.healthcre5302,
        • umi.nielsen_popfacts.cy_households.med_hinc_c46801,
        • umi.us_census.tract.lsad_name"Census Tract 119.02",
        • umi.geolytics.projection_year_expenditures.fawayfrhm2363,
        • umi.csmr_exp.attributes.plfeothpsinull,
        • umi.csmr_exp.attributes.etpublicnull,
        • umi.nielsen_popfacts.fy_households.med_rent_f41.3,
        • umi.geolytics.projection_year_expenditures.hsehldexp50205,
        • umi.csmr_exp.attributes.ehtelephnenull,
        • umi.csmr_exp.attributes.ptgasoilnull,
        • umi.geolytics.projection_year_housing_stats.med_grrnt2520,
        • umi.csmr_exp.attributes.ehmrtgintcnull
        }
      }
    ]
}

I'm trying to grab the value for umi.geolytics.projection_year_housing_stats.medhomval

In the webhooks config, I've tried:

features[0].properties.umi.geolytics.projection_year_housing_stats.medhomval
features[0].properties."umi.geolytics.projection_year_housing_stats.medhomval"
features[0].properties["umi.geolytics.projection_year_housing_stats.medhomval"]
features[0].properties["umi.geolytics.projection_year_housing_stats.medhomval"].value

None of which seem to work. Any ideas?
Tags (1)
3 REPLIES 3
Anonymous
Not applicable

Re: Parsing JSON response from webhook

bump
Anonymous
Not applicable

Re: Parsing JSON response from webhook

bump2
Anonymous
Not applicable

Re: Parsing JSON response from webhook

Please test to see if any of these response mappings work: 

features.properties[2]
features.properties[2].umi.geolytics.projection_year_expenditures.entertain
features.properties[2].umi.geolytics.projection_year_expenditures.entertain[0]