logo标签列表

从PayPal SOAP API获取交易详情（希望包括自定义字段）

paypalpaypal-rest-sdkpaypal-soap
7
我想从PayPal的SOAP API获取交易明细，但我遇到了PayPal返回的错误。它返回以下错误信息：

The transaction id is not valid

我知道这是一个有效的交易ID，因为我能够使用PayPal NVP API获取交易详情，但可能我格式化了SOAP请求。我按照网络上可以找到的PayPal SOAP API示例构建SOAP XML，但它们很简略。我正在使用mac的PAW程序向PayPal的API发送SOAP请求，但这个问题应该可以使用HTTP客户端重现。
我尝试使用PayPal的REST API，但没有方法获取交易详情（例如名称、电子邮件、已支付金额、自定义字段）。我还尝试使用NVP（Name-Value-Pair）API，我确实获得了交易详情，但它没有给我所有存储的交易自定义字段。当我登录PayPal并查看单个交易时，我可以看到该交易的所有自定义字段，所以我知道它们被存储了。
SOAP API是我的最后希望。
以下是我使用的SOAP信封请求：
 <?xml version="1.0" encoding="UTF-8"?>
 <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="urn:ebay:api:PayPalAPI" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:ed="urn:ebay:apis:EnhancedDataTypes">
      <soapenv:Header>
           <ns:RequesterCredentials>
                <ebl:Credentials>
                     <ebl:Username>soap_api_username_here</ebl:Username>
                     <ebl:Password>soap_api_password_here</ebl:Password>
                     <ebl:Signature>soap_api_signature_here</ebl:Signature>
                </ebl:Credentials>
           </ns:RequesterCredentials>
      </soapenv:Header>
      <soapenv:Body>
           <ns:GetTransactionDetailsReq>
                <ns:GetTransactionDetailsRequest>
                     <ebl:Version>93.0</ebl:Version>
                     <ebl:TransactionID>8FX18476NR449891W</ebl:TransactionID>
                </ns:GetTransactionDetailsRequest>
           </ns:GetTransactionDetailsReq>
      </soapenv:Body>
 </soapenv:Envelope>

这是我从PayPal SOAP API收到的响应：
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:wsu="http://schemas.xmlsoap.org/ws/2002/07/utility" xmlns:saml="urn:oasis:names:tc:SAML:1.0:assertion" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext" xmlns:ed="urn:ebay:apis:EnhancedDataTypes" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:ns="urn:ebay:api:PayPalAPI">
      <SOAP-ENV:Header>
        <Security xmlns="http://schemas.xmlsoap.org/ws/2002/12/secext" xsi:type="wsse:SecurityType"/>
        <RequesterCredentials xmlns="urn:ebay:api:PayPalAPI" xsi:type="ebl:CustomSecurityHeaderType">
          <Credentials xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:UserIdPasswordType">
            <Username xsi:type="xs:string"/>
            <Password xsi:type="xs:string"/>
            <Signature xsi:type="xs:string"/>
            <Subject xsi:type="xs:string"/>
          </Credentials>
        </RequesterCredentials>
      </SOAP-ENV:Header>
      <SOAP-ENV:Body id="_0">
        <GetTransactionDetailsResponse xmlns="urn:ebay:api:PayPalAPI">
          <Timestamp xmlns="urn:ebay:apis:eBLBaseComponents">2016-08-02T16:43:02Z</Timestamp>
          <Ack xmlns="urn:ebay:apis:eBLBaseComponents">Failure</Ack>
          <CorrelationID xmlns="urn:ebay:apis:eBLBaseComponents">a464c181339f4</CorrelationID>
          <Errors xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:ErrorType">
            <ShortMessage xsi:type="xs:string">Transaction refused because of an invalid argument. See additional error messages for details.</ShortMessage>
            <LongMessage xsi:type="xs:string">The transaction id is not valid</LongMessage>
            <ErrorCode xsi:type="xs:token">10004</ErrorCode>
            <SeverityCode xmlns="urn:ebay:apis:eBLBaseComponents">Error</SeverityCode>
          </Errors>
          <Version xmlns="urn:ebay:apis:eBLBaseComponents">93.0</Version>
          <Build xmlns="urn:ebay:apis:eBLBaseComponents">000000</Build>
          <PaymentTransactionDetails xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:PaymentTransactionType">
            <ReceiverInfo xsi:type="ebl:ReceiverInfoType"/>
            <PayerInfo xsi:type="ebl:PayerInfoType">
              <PayerStatus xsi:type="ebl:PayPalUserStatusCodeType">verified</PayerStatus>
              <PayerName xsi:type="ebl:PersonNameType"/>
              <Address xsi:type="ebl:AddressType">
                <AddressOwner xsi:type="ebl:AddressOwnerCodeType">PayPal</AddressOwner>
                <AddressStatus xsi:type="ebl:AddressStatusCodeType">None</AddressStatus>
              </Address>
            </PayerInfo>
            <PaymentInfo xsi:type="ebl:PaymentInfoType">
              <TransactionType xsi:type="ebl:PaymentTransactionCodeType">none</TransactionType>
              <PaymentType xsi:type="ebl:PaymentCodeType">none</PaymentType>
              <PaymentStatus xsi:type="ebl:PaymentStatusCodeType">None</PaymentStatus>
              <PendingReason xsi:type="ebl:PendingStatusCodeType">none</PendingReason>
              <ReasonCode xsi:type="ebl:ReversalReasonCodeType">none</ReasonCode>
            </PaymentInfo>
            <PaymentItemInfo xsi:type="ebl:PaymentItemInfoType">
              <Subscription xsi:type="ebl:SubscriptionInfoType"/>
              <Auction xsi:type="ebl:AuctionInfoType"/>
            </PaymentItemInfo>
          </PaymentTransactionDetails>
        </GetTransactionDetailsResponse>
      </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

我不确定自己做错了什么，也许有更多经验的人比我更容易发现错误。我回答了另一个用户关于PayPal REST API和从中获取交易详情的问题，但据我所知，没有办法做到这一点Get customer details after transaction。如果您已经找到了使用REST API实现此目标的方法，请告诉我，因为我宁愿使用REST而不是SOAP。
谢谢。
你使用的服务器端语言是什么，用于发送和接收？我正在使用asp.net，但很确定它不使用XML。 - JustJohn
@JustJohn 我原本计划使用PHP调用PayPal SOAP API，但如果我无法在Paw或Postman中使其正常工作，我怀疑PHP调用也不会奏效，只会让我更加困惑。如果您正在使用PayPal SOAP API，则ASP.net程序正在编译XML调用以发送到PayPal SOAP API。 - De'Yonte W.
2个回答
1
错误信息是一个误导，PayPal无法找到任何TransactionId，并将空的TransactionId报告为无效。
TransactionId元素属于urn：ebay：api：PayPalAPI命名空间。您的XML将其附加到urn：ebay：apis：eBLBaseComponents命名空间。您只需要将ebl：TransactionId更改为ns：TransactionId即可。
 <?xml version="1.0" encoding="UTF-8"?>
  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="urn:ebay:api:PayPalAPI" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:ed="urn:ebay:apis:EnhancedDataTypes">
  <soapenv:Header>
       <ns:RequesterCredentials>
            <ebl:Credentials>
                 <ebl:Username>soap_api_username_here</ebl:Username>
                 <ebl:Password>soap_api_password_here</ebl:Password>
                 <ebl:Signature>soap_api_signature_here</ebl:Signature>
            </ebl:Credentials>
       </ns:RequesterCredentials>
  </soapenv:Header>
  <soapenv:Body>
      <ns:GetTransactionDetailsReq>
           <ns:GetTransactionDetailsRequest>
                <ebl:Version>204.0</ebl:Version>
                <ns:TransactionID>8FX18476NR449891W</ns:TransactionID>
           </ns:GetTransactionDetailsRequest>
      </ns:GetTransactionDetailsReq>
 </soapenv:Body>

请查看PayPal知识库中的示例。

这个可以工作。看起来PayPal的SOAP API仍然只能检索它可以存储的七个选项中的两个。这是NVP和SOAP API的已知问题。http://stackoverflow.com/questions/16764186/gettransactiondetails-doesnt-report-part-of-the-order-options - De'Yonte W.
0

我本来想把这个作为评论，但它充满了一些难以理解的术语。虽然可能偏离主题，但我或许能提供一些帮助。 我的VB.NET代码向PayPal发送一个包含“notify_url”的表单。

            ' determining the URL to work with depending on whether sandbox or a real PayPal account should be used
            If strRealOrSand = "Sand" Then
                URL = "https://www.sandbox.paypal.com/cgi-bin/webscr"
                business = "x@xxx.com"  ' AppSettings("BusinessEmail")  (sandbox account business email)
            ElseIf strRealOrSand = "Real" Then
                URL = "https://www.paypal.com/cgi-bin/webscr"
                business = "xxx@xxx.com"    ' AppSettings("BusinessEmail")  (real pay pal account account business email)
            End If

notify_url = "http://www.xxxxx.com/accounts/done.aspx"  



    <form id="payForm" method="post" action="<%Response.Write (URL)%>" >
        <input type="hidden" name="cmd" value="<%Response.Write (cmd)%>" />
        <input type="hidden" name="business" value="<%Response.Write (business)%>" />
        <input type="hidden" name="item_name" value="<%Response.Write (item_name)%>" />
        <input type="hidden" name="amount" value="<%Response.Write (amount)%>" />
        <input type="hidden" name="no_shipping" value="<%Response.Write (no_shipping)%>" />
        <input type="hidden" name="return" value="<%Response.Write (return_url)%>" />
        <input type="hidden" name="rm" value="<%Response.Write (rm)%>" />
        <input type="hidden" name="notify_url" value="<%Response.Write (notify_url)%>" />
        <input type="hidden" name="cancel_return" value="<%Response.Write (cancel_url)%>" />
        <input type="hidden" name="currency_code" value="<%Response.Write (currency_code)%>" />
        <input type="hidden" name="custom" value="<%Response.Write (row_id)%>" />
    </form>

    <script type="text/javascript">
        document.forms["payForm"].submit ();
    </script>

</body>

然后在我的“notify_url”页面加载时，它会获取PayPal在交易完成后发送回来的内容。您会注意到有大量的调试电子邮件被发送回给我。这是我自己做的。

   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim vReceived As String = ""
        Dim vFormValues As String = ""
        Dim vResponder As String = ""
        Dim strE As String = ""
        Dim intAccountID As Integer = 0
        Dim intCreditsPurchased As Integer = 0

        Dim vWebRequest As System.Net.HttpWebRequest
        Dim vSSend As Boolean = False
        'vWebRequest = CType(System.Net.WebRequest.Create("https://www.sandbox.paypal.com/cgi-bin/webscr"), System.Net.HttpWebRequest)
        vWebRequest = CType(System.Net.WebRequest.Create("https://www.paypal.com/cgi-bin/webscr"), System.Net.HttpWebRequest)



        vWebRequest.Method = "POST"
        vWebRequest.ServicePoint.Expect100Continue = False
        vWebRequest.ContentType = "application/x-www-form-urlencoded"



        Try
            vFormValues = Encoding.ASCII.GetString(Request.BinaryRead(Request.ContentLength))
            vReceived = "cmd=_notify-validate&" & vFormValues
        Catch ex As Exception
            sSend_Mail_From_done_aspx("Requested Form.ToString", ex.ToString)
        End Try

        vWebRequest.ContentLength = vReceived.Length
        Dim vStreamOut As System.IO.StreamWriter = New System.IO.StreamWriter(vWebRequest.GetRequestStream(), Encoding.ASCII)
        vStreamOut.Write(vReceived)
        vStreamOut.Close()
        Dim vStreamIn As New System.IO.StreamReader(vWebRequest.GetResponse().GetResponseStream())
        vResponder = vStreamIn.ReadToEnd()
        vStreamIn.Close()



        Dim vFieldName As String
        Dim vFieldValue As String = ""
        Dim vFields As New Collection

        For Each vFieldName In Request.Form
            'strE = strE & Request.Form.Item(vFieldName) & " "
            strE &= vFieldName & ": " & Request.Form.Item(vFieldName) & vbCrLf
            'vFieldValue = Request.Form.Item(vFieldName)
            'vFields.Add(Decode(vFieldValue), Decode(vFieldName).ToLower)
        Next

        sSend_Mail_From_done_aspx("BEFORE VERIFIED CHECK, WHAT vResponder CONTAINS", strE)


        Dim transactionID As String = ""
        Dim dblAmount As Double
        Dim intRowID As Integer
        Dim dblPayPalFee As Double

        Dim strMemo As String = ""
        Dim strPayerEmail As String = ""
        Dim strPaymentDate As String = ""

        If Trim(vResponder).ToUpper = "VERIFIED" Then

            For Each vFieldName In Request.Form
                strE &= vFieldName & ": " & Request.Form.Item(vFieldName) & vbCrLf

            Next

            sSend_Mail_From_done_aspx("VERIFIED CAME THROUGH", strE)

            Try
                transactionID = Request.Form.Item("txn_id").ToString()
                dblAmount = CType(Request.Form.Item("payment_gross"), Double)
                intRowID = CType(Request.Form.Item("custom"), Integer)
                dblPayPalFee = CType(Request.Form.Item("payment_fee"), Double)
                If Len(Request.Form.Item("memo") & "") <> 0 Then
                    strMemo = Request.Form.Item("memo").ToString.Replace("'", "")
                End If
                strPayerEmail = Request.Form.Item("payer_email").ToString
                strPaymentDate = Request.Form.Item("payment_date").ToString


            Catch ex As Exception
                sSend_Mail_From_done_aspx("Request.QueryString)", ex.ToString)
            End Try


            Try

                '==============================
                'SAVE TRANSACTION INFO HERE
                '==============================
                Dim sb As New StringBuilder
                sb.Append("UPDATE dbo.tblTransactions ")
                sb.Append("SET pp_txn_id='" & transactionID & "'")
                sb.Append(", pp_payment_gross=" & dblAmount)
                sb.Append(", pp_mc_fee=" & dblPayPalFee)
                sb.Append(", memo='" & strMemo & "'")
                sb.Append(", pp_payer_email='" & strPayerEmail & "'")
                sb.Append(", pp_payment_date='" & strPaymentDate & "'")
                sb.Append(" WHERE RowID =" & intRowID)

                'SEND SQL TO DEVELOPER
                sSend_Mail_From_done_aspx("INSERT statement BEFORE action", sb.ToString)

                Dim conn As New SqlConnection(f1.fUseThisConnection(Server.MachineName))
                Dim cmd As New SqlCommand(sb.ToString, conn)

                cmd.Connection.Open()
                cmd.ExecuteNonQuery()

                '=========================================================
                'UPDATE ACCOUNT INFO HERE (ADD CREDITS TO CURRENT AMOUNT)
                '=========================================================
                Dim dr As System.Data.SqlClient.SqlDataReader


                sb.Length = 0
                'GET ACCOUNT ID, AND CreditsPurchased
                sb.Append("SELECT AccountID, CreditsPurchased FROM dbo.tblTransactions ")
                sb.Append(" WHERE RowID =" & intRowID)

                cmd.CommandText = sb.ToString
                dr = cmd.ExecuteReader()

                If dr.Read() Then

                    intAccountID = dr("AccountID")
                    intCreditsPurchased = dr("CreditsPurchased")


                End If

                dr.Close()


                sb.Length = 0

                'AT 1.10 A CREDIT, WE DIVIDE THE AMOUNT PAYPAY CHARGES BY THIS TO GET CREDITS PURCHASED

                sb.Append("UPDATE dbo.tblAL SET Credits = Credits + " & intCreditsPurchased)
                sb.Append(" WHERE AccountID =" & intAccountID)

                cmd.CommandText = sb.ToString
                cmd.ExecuteNonQuery()

                'SEND ACCOUNT UPDATE AMOUNT TO DEVELOPER
                sSend_Mail_From_done_aspx(intCreditsPurchased & " CREDITS ADDED TO ", sb.ToString)

                cmd.Dispose()
                conn.Close()
                conn = Nothing

                MySession.Credits = intCreditsPurchased


            Catch ex As Exception
                sSend_Mail_From_done_aspx("tblTransactions NOT UPDATED with Transaction Info", ex.ToString())
            End Try

        Else
            sSend_Mail_From_done_aspx(Trim(vResponder).ToUpper, "TRANSACTION NOT VERIFIED")

        End If
    End Sub

我认为请求/响应如下：

提交的表单

URL = "https://www.paypal.com/cgi-bin/webscr"

发送回提交的“notify_url”内部

Dim vWebRequest As System.Net.HttpWebRequest
            Dim vSSend As Boolean = False
            'vWebRequest = CType(System.Net.WebRequest.Create("https://www.sandbox.paypal.com/cgi-bin/webscr"), System.Net.HttpWebRequest)
            vWebRequest = CType(System.Net.WebRequest.Create("https://www.paypal.com/cgi-bin/webscr"), System.Net.HttpWebRequest)

真希望有一个“PayPalFiddle”哈哈

网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接