Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Share tech news, updates, or what's on your mind.

Sign up to Post

In Ms Access I am trying to make a API call to Paypal to try them out. But no matter what I get a Error "0". Does anyone have any idea what the problem is. I have put my code below.

Option Compare Database
Option Explicit
Public Function PayPalGetTransactionDetails()

'On Error GoTo Errorhandler

    Dim Http As New msxml2.XMLHTTP60
    Dim Doc As New msxml2.DOMDocument
    Dim fp1 As String
    Dim fp2 As String
    Dim XmlString As String
    Dim UrlPath As String
    Dim TransactionIdValue As String
    Dim APICALL As String
    Dim UserNameValue As String
    Dim PassWordValue As String
    Dim SignatureValue As String
    Dim SubjectValue As String
    UserNameValue = "MyUserName_api5.gmail.com" 'API Paypal User Name
    PassWordValue = "MyPassowrd" 'API Paypal Password
    SignatureValue = "MySigvalue" 'Supplied by Paypal.
    APICALL = "GetTransactionDetails"
    SubjectValue = "Dgstgsgsh@gmail.com"
    fp1 = "C:\Database\ExportedOrders\PaypalApiTestRequests\"
    fp2 = "C:\Database\ExportedOrders\PaypalApiTestResponses\"
    UrlPath = "https://api-3t.paypal.com/2.0/"
    TransactionIdValue = "57547564e67744757"
    Http.Open "POST", UrlPath, False
'    Http.setRequestHeader "CONTENT-TYPE", "text/html"
'    Http.setRequestHeader "Username", UserNameValue
'    Http.setRequestHeader "Password", PassWordValue
'    Http.setRequestHeader "Signature", SignatureValue

    XmlString = "<?xml version=""1.0"" encoding=""UTF-8""?>" & 

Open in new window

Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

How can i access the type Attributes directly if my XmlNode holds the below xml file.

i tried the following with no luck
dim elementPath as String = "ns:RequestedAddr/ns:type"
dim elementPath as String = "ns:RequestedAddr/type"
dim elementPath as String = "RequestedAddr/type"

Dim myNode As XmlNode = node.Attributes(elementPath)

I need to check if the node / Attribute exists to avoid null exceptions

        <RequestedAddr type="unknown">12099925140</RequestedAddr>
        <DestAddr type="e164">+12099925140</DestAddr>
        <RoutedAddr type="national">2099925140</RoutedAddr>
        <CallingPartyRoutedAddr type="national">2099313552</CallingPartyRoutedAddr>
        <CallingPartyOrigAddr type="national">2099313552</CallingPartyOrigAddr>

Open in new window

Please help... this code is not showing any result........

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/collection">
<b> <xsl:text>* bookk details sortedin descending order of their pric*</xsl:text></b>

<xsl:for-each select="bookinfo/book">
<xsl:sort select="price" data-type="number" order="descending"/>
<xsl:value-of select="@bookid"/> </br>
<xsl:value-of select="bookname"/> </br>
<font color="red"><xsl:apply-templates select="price"/></font><br/>


<?xml version="1.0" ?>
<?xml-stylesheet href="C:\Users\ajasawant\Downloads\AIT PRoject\xml practice\bookstylesheet.xsl" type="text/xsl" ?>
<book bookid="B001" category="practical">
<bookname>php and xml</bookname>
<authorname>neelima padmawar</authorname>
<book bookid="B002" category="practical">
<authorname>alok pawar</authorname>
Hi,  Thankyou experts for helping out!

i am submitting some data to an API.

I get back the below packet:
object(stdClass)#4 (7) {
  array(1) {
    object(stdClass)#5 (7) {
      string(31) "Tue, 13 Mar 2018 00:02:15 +0000"
      string(32) "406e3658b6c0c0984dacee9298b0c5d8"
      string(10) "0419697XXX"
      string(11) "61402374XXX"
      string(86) "Hi Jimmy, Broken SMS begun."
      string(48) "/2016-11-30/sms/406e3658b6c0c0984dacee9298b0c5d8"
      object(stdClass)#6 (1) {
        string(31) "Tue, 13 Mar 2018 00:02:25 +0000"
  string(16) "Response follows"
  string(10) "2016-11-30"
  string(48) "/2016-11-30/sms/406e3658b6c0c0984dacee9298b0c5d8"

Open in new window

Could someone please help me serialise it?

I want to gain access to this part:
      object(stdClass)#6 (1) {
        string(31) "Tue, 13 Mar 2018 00:02:25 +0000"

Open in new window

Basically I want whatever is in the section "Delivered".

Could someone please help?
Experts, please let me know if you can recommend any free XML validation tool (not the generic plugins available in Notepad++, browser, etc) which is more advanced in terms of debugging the errors. Please recommend only if you have personally used it.
Hi Experts

Could you clear what is and what is causing this VFP  XML Web Service, correctly registered when running?

if the line
leResult = loHello_Port.sayHello('xxx')

Open in new window

is ommited - no problems arises

if the line is changed to:
leResult = loHello_Port.sayHello()

Open in new window

this error arises

<definitions name = "HelloService"
   targetNamespace = "http://www.xxxxx.com.br/soap/HelloService.wsdl"
   xmlns = "http://schemas.xmlsoap.org/wsdl/"
   xmlns:soap = "http://schemas.xmlsoap.org/wsdl/soap/"
   xmlns:tns = "http://www.xxxx.com.br/wsdl/HelloService.wsdl"
   xmlns:xsd = "http://www.w3.org/2001/XMLSchema">
   <message name = "SayHelloRequest">
      <part name = "firstName" type = "xsd:string"/>
   <message name = "SayHelloResponse">
      <part name = "greeting" type = "xsd:string"/>

   <portType name = "Hello_PortType">
      <operation name = "sayHello">
         <input message = "tns:SayHelloRequest"/>
         <output message = "tns:SayHelloResponse"/>

   <binding name = "Hello_Binding" type = "tns:Hello_PortType">
      <soap:binding style = "rpc"
         transport = "http://schemas.xmlsoap.org/soap/http"/>
      <operation name = "sayHello">
         <soap:operation soapAction = "sayHello"/>
               encodingStyle = "http://schemas.xmlsoap.org/soap/encoding/"

Open in new window


How can create a xml file based in a xsd file. Data source is a datatable.

best regards
<XML ID="#xmlbill" SRC="bill.xml"></XML>
<table datasrc="#xmlBill" border=1>
      <td><div datafld="billno"></div></td>
      <td><div datafld="billdate"></div></td>
      <td><div datafld="PONO"></div></td>
      <td><div datafld="billamt"></div></td>
      <td><div datafld="billduedate"></div></td>
<?xml version="1.0"?>
Eliminate empty tags from XML. Sample XML is like
                                <DepartureDate>19-Jun-2018</DepartureDate><ArrivalDate /><DepartureTime /><ArrivalTime /></OriginDestinationDetails><PreferredFlightDetails />
I want to remove empty tags like SessionToken, ArrivalDate  etc.
And I want to save the final XML in a string.
VB.Net, xml to web service

How to add more parameter at CHECK_OUT such s Target,TimeStamp,AuthKey?
<?xml version="1.0" encoding="utf-8"?>
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
  <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <CHECK_OUT Target="Test" TimeStamp="2016-06-02T12:12:12.8028213+02:00" AuthKey="XXXXX" Release="1.4" xmlns="http://domain.com">
      <Info Code="1930"/>
        <UniqueID ID="152" Type="114"/>
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

what are some real world (may be even cool)  example or applications, anyone has worked on ,  in XSL (eXtensible Stylesheet Language) and XSLT trasformation?
I have created an application developped by Embarcadero XE5 C++. I use THTTPRio to consume a web service.
I have a problem with the request message generated by our application. It seems that namespaces are missing in the soap message for NS1, NS2 and NS3.
I think there's a bug in the Embarcadero.

Here the SOAP request message generated by Embarcadero:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <G110Request xmlns="urn:wsdltypes.nmvs.eu:v1.0">
                  <Header xmlns="urn:types.nmvs.eu:v1.0">
                        <UserSoftware NS1:name="xxxxx" NS2:supplier="xxxx"/>
                  <Body xmlns="urn:types.nmvs.eu:v1.0">
                              <ProductCode NS3:scheme="GTIN">1234567891234</ProductCode>

Thanks for your help
12345.xmlUnrecognized input signature.
  Line 1, Position 3
This Dialogue Shows when opening my xml files

I wants til insert a xml node/node with child into an existing XML fil.
But I need it to be after a specific node :) -  "OrderReference"

The Existing File looks like this :
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href=""?>
<Invoice xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ccts="urn:oasis:names:specification:ubl:schema:xsd:CoreComponentParameters-2" xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:sdt="urn:oasis:names:specification:ubl:schema:xsd:SpecializedDatatypes-2" xmlns:udt="urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2 UBL-Invoice-2.0.xsd">
						<cbc:ID schemeID=""></cbc:ID>

Open in new window

looking for some vba coding to parse thru an xml file, need to extract : the following fields:Vendor FirmID and Name,UserID,lastname,firstname,email,along with the credits and credits detail information.
New to XML and lost as where to begin
Hello, I have a table which has a xml column and two varchar columns, and I would like to send this table as an email report.
I used SQL Server Database mail and scripts similar as below, but the xml column becomes NULL in the email report.   May I ask if someone knows how I can send the email, with both varchar data and xml data? I would like the xml data to show in xml format so that user can click on it for more details..  Thanks in advance :-)

SET @tableHTML =
body {font-family: Verdana;}
 N'<table border="1" width="90%">' +
      CAST ( ( SELECT td = Duration,'',
                    td = SessionID, '',
                    td = SQL_Text, ''
  from Table FOR XML PATH('tr'), TYPE  
    ) AS xml ) +     N'</table><br><br>'    ;
declare @subject varchar(300)
select @subject='email report'
EXEC msdb.dbo.sp_send_dbmail
@subject = @subject,
@body = @tableHTML,
@body_format = 'HTML'
I'm using the following to display numbers from an xml in an asp page

For Each xmlNode In objXML.documentElement.selectNodes("Data[FundCode/text()='" & neaFundID & "']")

NEADayPnL = xmlNode.selectSingleNode("DayPnL").text


***then im creating a recordset to load up the data ***

Set objRsBC  = CreateObject("ADODB.recordset")

            objRsBC.Fields.Append "NNWDayPnL", adVarChar, 100

objRsBC.open, , 2, 3
                  objRsBC.Fields("NNWDayPnL") = NNWDayPnL

then I'm calling  a function to display the number...

<%call vbproc(objRsBC("NNWSLDayPnL"), objRsBC("NNWSLDayPnL").name)%>

seems long winded, how would I select a single node and display the number with out creating a record set etc...

We want to create an APIs in .net platform. Is there an third party tool which will create the API faster and response format should be JSON, XML and soap based APIs.

Which is the tool for API documentations.
I am going to try and explain this the best I can and I hope everyone understands and can help.  
*****I am not sure if in the XML file what I am referring to is called a Node, Boundary Tag, or Element. So I will call it a Node.****

I am importing a XML file into MS Access by VBA and when I do this Access separates the Children Nodes from the Parent Node and makes the Children Nodes tables and then puts the Grandchildren Nodes in the Children table as Field Names.

Here is a XML sample:
<?xml version="1.0" encoding="utf-8"?>

Open in new window

In my scenario here Access Makes these table:

These Fields:

So how can I get Access to either import all the Children and Grandchildren into a single table or how can I link these tables to show John Doe was OrderID 1234????

Thank you for the help?
Free Tool: Site Down Detector
LVL 12
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have SQL server 2012.

I need to set up an automated export of data to XML format and email to a set of people every day.

I can run the query to select the data I want.  Im just not sure how to export that data to an XML form.
How do I make a product selection guide with CSS, Javascript, and a database (or without a database if that is possible). XML allowed.

What it would do is be 5 dropdowns and a submit button.

Say it's for shoes and, for simplicity, has 3 dropdown.

The first dropdown would be either running, walking, cross-train, casual, etc
The second dropdown would be color
The third dropdown would be size of foot

You would press submit and a div would pop out of the bottom under the submit button with all the products on our site that matched the dropdown choices.

Would love to do this with pure CSS or pure CSS and XML, but
if we need to add javascript we can
If we need to add a mySQL database we can

Let me know what the simplest way to set this up is. Not looking for CSS help, looking for general outline of how to do this.

Will gather code details later, just need a basic overview. Coding details is a plus if you want to offer it.


My company has recently re-branded and I have created new PowerPoint, Excel and Word templates.
In Office I have created my colour palettes which are very useful, but these dont go across with the PowerPoint/Excel/Word files.

Ive been looking into it and it create an XML file on the machine with all the colours within that palette.
C:\Users\user\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors\Name.xml

I would like an easy way for everyone else in the company to copy this XML onto their computer.

Can this be done with a batch script??

Any advice?

How can I convert xml files to jpeg?
Consuming ASPNET WSDL service using PHP
Hi Experts,
having some serious issues getting this one right. I am writing a PHP web app that needs to post an xml to an ASPNET WSDL service. Upon submitting data via PHP service it gives me an error "SoapFault exception: [s:Client] An error has occurred during service execution halting any further processing."
I then decided to use ReadyAPI and the error it gives is "HTTP/1.1 415 Cannot process the message because the content type 'multipart/related; type="text/xml"; start="<rootpart@soapui.org>"; boundary="----=_Part_0_2905742.1520010170903"' was not the expected type 'text/xml; charset=utf-8'."

Really baffled with this one. Have tried so many different soap codes to submit data and same response. any suggestions?

I am  trying to compile a 2010 project .soln on visual studio 2017 . It had several references to other *2008.vcxproj

I have renamed the  *2008.vcxproj , *2008.vcproj to *2010.vcproj so that i could get it to work and then retarget the whole thing t o 2017.

However, it didn't work. And now, i get complaints about

Collection was modified. enumeration operation may not execute. <------ What does this error mean anyway?

whenever i attempt to retarget solution.

What (and where) needs to be done to manually modify the xml vcxproj so that i can modify everything once and have it target to 2017 successfully?







Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).