Azure Data Factory - Paypal - Lookup error

Ana Del Campo 121 Reputation points Microsoft Employee
2020-11-16T04:59:23.097+00:00

I am trying to execute a lookup to read records from Paypal:

This is the query I am running

Select Id,Transactions_Index,Sale_Create_Time,Sale_Parent_Payment,Sale_Amount_Details_Subtotal, Sale_Id from Payment_Transactions_Sale Where Sale_Create_Time >= 2020-11-14T23:59:55Z

and this is the error that I am getting back:

ERROR [42000] [Microsoft][SQLEngine] (31480) syntax error near 'Select Id,Transactions_Index,Sale_Create_Time,Sale_Parent_Payment,Sale_Amount_Details_Subtotal, Sale_Id from Payment_Transactions_Sale Where Sale_Create_Time =><<< ??? >>>2020-11-14T23:59:55Z'.,Source=PayPalODBC_sb64.dll,

Any ideas or pointers

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2020-11-17T01:19:17.313+00:00

    Hello @Ana Del Campo ,

    Thanks for the ask , I justed tested the below query will work , I have no data to check if it really pulls any data though :)

    Select Id,Transactions_Index,Sale_Create_Time,Sale_Parent_Payment,Sale_Amount_Details_Subtotal, Sale_Id from Payment_Transactions_Sale Where Sale_Create_Time >= '2020-11-14T23:59:55Z' .

    Do let me know how it goes .

    Thanks Himanshu
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

    0 comments
  2. Ana Del Campo 121 Reputation points Microsoft Employee
    2020-11-17T01:22:19.28+00:00

    Thank you @HimanshuSinha-msft

    I used the exact query, I got this error

    Odbc Operation Failed.
    ERROR [22018] [Microsoft][Support] (40550) Invalid character value for cast specification.
    . Activity ID: c1bf03e1-faf1-4eb4-84b0-42b1f3d63b43

    been going around in circles with this..

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.