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