Skip to content

Instantly share code, notes, and snippets.

@iwate
Created September 7, 2016 06:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iwate/471f1d3871b4f9e1dcd76c95feed1dca to your computer and use it in GitHub Desktop.
Save iwate/471f1d3871b4f9e1dcd76c95feed1dca to your computer and use it in GitHub Desktop.
This query is faild in DataFactory, why?
{
"name": "AzureStorageLinkedService",
"properties": {
"type": "AzureStorage",
"typeProperties": {
"connectionString": "DefaultEndpointsProtocol=https;AccountName=*******;AccountKey=**********"
}
}
}
Data Type Object is not supported. Detailed Message: ErrorCode=DataTypeNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column: ProductID,The data type Object is not supported.,Source=,'
{
"name": "Exports",
"properties": {
"activities": [
{
"type": "Copy",
"typeProperties": {
"source": {
"type": "RelationalSource",
"query": "$$Text.Format('ProductDetails?$filter=Product/ReleaseDate ge datetime\\'{0:yyyy-01-01}\\' and Product/ReleaseDate lt datetime\\'{1:yyyy-01-01}\\'', WindowStart, WindowEnd)"
},
"sink": {
"type": "BlobSink",
"writeBatchSize": 0,
"writeBatchTimeout": "00:00:00"
}
},
"inputs": [
{
"name": "OData"
}
],
"outputs": [
{
"name": "ProductDetails"
}
],
"policy": {
"timeout": "02:00:00",
"concurrency": 1,
"style": "StartOfInterval",
"retry": 3,
"longRetry": 0,
"longRetryInterval": "00:00:00"
},
"scheduler": {
"frequency": "Month",
"interval": 12
},
"name": "FreeOdata"
}
],
"start": "2000-01-01T00:00:00Z",
"end": "2009-01-01T00:00:00Z",
"isPaused": false,
"pipelineMode": "Scheduled"
}
}
{
"name": "OData",
"properties": {
"published": false,
"type": "ODataResource",
"linkedServiceName": "ODataLinkedService",
"typeProperties": {},
"availability": {
"frequency": "Month",
"interval": 12
},
"external": true,
"policy": {}
}
}
{
"name": "ODataLinkedService",
"properties": {
"type": "OData",
"typeProperties": {
"url": "http://services.odata.org/V3/OData/OData.svc",
"authenticationType": "Anonymous"
}
}
}
{
"name": "ProductDetails",
"properties": {
"published": false,
"type": "AzureBlob",
"linkedServiceName": "AzureStorageLinkedService",
"typeProperties": {
"fileName": "{year}/ProductDetails",
"folderPath": "<container>",
"format": {
"type": "JsonFormat",
"filePattern": "arrayOfObjects"
},
"partitionedBy": [
{
"name": "year",
"value": {
"type": "DateTime",
"date": "SliceStart",
"format": "yyyy"
}
}
]
},
"availability": {
"frequency": "Month",
"interval": 12
},
"external": false,
"policy": {}
}
}
http://services.odata.org/V3/OData/OData.svc/ProductDetails?$filter=Product/ReleaseDate ge datetime'2003-01-01' and Product/ReleaseDate lt datetime'2004-01-01'&$format=json
{
"odata.metadata":"http://services.odata.org/V3/OData/OData.svc/$metadata#ProductDetails",
"value":[
{
"ProductID":4,
"Details":"Details of product 4"
}
]
}
@CloudCurry
Copy link

Any luck with this? ended up in same issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment