Forum Discussion
Pipeline REST filter query to Xero
Hi there, I am trying to import data from Xero using a pipeline and do so fine when I do not filter the REST request. But when I try to add a standard filter to the REST call, I receive the below err...
It seems as though Data Factory keeps trying to convert the DateTime string I am passing to Xero in the REST query. I've tried to convert it into a string, or somehow use a string literal, but Data Factory keeps trying to convert the DateTime into a function instead of passing it as a string to Xero. Any help would be massively appreciated.
Thanks
ericpasztor
Microsoft
Microsofttuck411, if using a Mapping Data Flow, can you try to set the Base URL of the REST call to be parameterized based on a variable which represents the date value? See "Example 1: Variables in QueryParameters" within this documentation.
Something like "https://api.xero.com/api.xro/2.0/Invoices?where=Date >= {varInvoiceDate}" where varInvoiceDate is set as a string variable "DateTime(yyyy, mm, dd)".
