Error in feching values from XML document

Error in feching values from XML document

Hi,

I am using executeXPath to fetch values from XML document which is a Google MAP API. I am using the following command. The XPath builder shows correct result on execution. However the same value is not getting stored in Distance variable.  

The command is given below. I have also attached the screen shots showing the error and the XPath builder interface. The result is 17950 which should be stored in Distance. Using input.Distance also gives the same error.

Distance= input.Output.executeXPath("/DistanceMatrixResponse/row/element/distance/value/text()");

Distance is "Single Line" Field.

Can someone please help ?

Thanks,

Milind






          Zoho Marketing Automation

                  Zoho Pagesense Resources

                    Zoho SalesIQ Resources



                          Zoho TeamInbox Resources

                            Zoho DataPrep Resources



                              Zoho CRM Plus Resources

                                Zoho Books Resources


                                  Zoho Subscriptions Resources

                                    Zoho Desk Resources

                                      Zoho Projects Resources


                                        Zoho Sprints Resources


                                          Qntrl Resources


                                            Zoho Creator Resources


                                              Zoho WorkDrive Resources





                                                  Zoho Campaigns Resources

                                                    Zoho CRM Resources

                                                          Design. Discuss. Deliver.

                                                          Create visually engaging stories with Zoho Show.

                                                          Get Started Now