Error in feching values from XML document

Error in feching values from XML document


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 ?



      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