Skip to main content
  • EN

Hi team.

I extracted json from http caller. extracted json file attached. json.txt.

in this json there are array of points. the path of these points is. ucan see these points after "paths"

(text string)

routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{0}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{1}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{0}.array{2}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{0}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{1}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{1}.array{2}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{2}.array{0}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{2}.array{1}
routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{2}.array{2}

here

array{0}.array{0} 😶 coordinate

array{0}.array{1} =y coordinate

array{0}.array{2} =z coordinate.

using xy cordinate value i want to create a line vertexes using point connector.

But i am not able to extract the array of coordinates from json .

Please help me. I have attached my fmw file.

Try the following JSON query in the JSONExtractor:

jsond"routes"]o0]e"routeOptions"]t0]n"optionAttributes"]b"spatialReference"]r"geometry"]

Then use a GeometryReplacer on the resulting JSON object with geometry type "ESRI JSON". I also suspect you'll want to use a GeometryRefiner and the ElevationToMeasureCopier (from the FME Hub) followed by a 2DForcer to move the Z-values to M-values on the resulting geometry. 

You can find the JSON query documentation for FME here:

http://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/jsonfragmenter.htm#JSON_Queries

I can also recommend this site where you can construct your JSON query string online while getting live results:

http://www.jsonquerytool.com/#/JavaScript

Try the following JSON query in the JSONExtractor:

jsond"routes"]o0]e"routeOptions"]t0]n"optionAttributes"]b"spatialReference"]r"geometry"]

Then use a GeometryReplacer on the resulting JSON object with geometry type "ESRI JSON". I also suspect you'll want to use a GeometryRefiner and the ElevationToMeasureCopier (from the FME Hub) followed by a 2DForcer to move the Z-values to M-values on the resulting geometry. 

You can find the JSON query documentation for FME here:

http://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/jsonfragmenter.htm#JSON_Queries

I can also recommend this site where you can construct your JSON query string online while getting live results:

http://www.jsonquerytool.com/#/JavaScript

Btw, thanks for giving us such a clear and reproducible case to work with! :-)

Thanks David.

I used below python code(iteration thru points)

then list exploder

vertex creator

point connector

this is the long process

i will replace yours now.

you are Genius.

import fme
import fmeobjects
import math


def frq(feature):
    a=0
    b=0
    while True:
        ol=feature.getAttribute("routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{"+ str(a)+"}.array{"+str(b)+"}")
        if ol is None:
            break
        feature.setAttribute("_list{%d}.x" % a, str(ol))
        b += 1
        print ol
        ol=feature.getAttribute("routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{"+ str(a)+"}.array{"+str(b)+"}")
        if ol is None:
            break
        print ol
        feature.setAttribute("_list{%d}.y" % a, str(ol))
        b =0
        a += 1


    

Thanks David.

I used below python code(iteration thru points)

then list exploder

vertex creator

point connector

this is the long process

i will replace yours now.

you are Genius.

import fme
import fmeobjects
import math


def frq(feature):
    a=0
    b=0
    while True:
        ol=feature.getAttribute("routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{"+ str(a)+"}.array{"+str(b)+"}")
        if ol is None:
            break
        feature.setAttribute("_list{%d}.x" % a, str(ol))
        b += 1
        print ol
        ol=feature.getAttribute("routes{0}.routeOptions{0}.optionAttributes.spatialReference.geometry.paths{0}.array{"+ str(a)+"}.array{"+str(b)+"}")
        if ol is None:
            break
        print ol
        feature.setAttribute("_list{%d}.y" % a, str(ol))
        b =0
        a += 1


    
Not a genius at all, just a long time user :-) Glad I could help.

Reply


Community Stats

30,092
Posts
114,247
Replies
37,720
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.