OData error calling function when identical table works fine

[Anonymous]

Hi, I have an odata function which I've setup to return exactly the same data as a entity table (verified json is the same through fiddler). However, the function call gives a json error, whist the table call works. If i reduce the size of one of the string fields, then the json parses no problem when called from the function. There seems to be something strange with the call to the odata function truncating the json value.

This works:

let
Source = OData.Feed("https://MYIP/odata", null, [Implementation="2.0"]),
tableData= Source{[Name="MYTABLE",Signature="table"]}[Data],
#"Kept First Rows" = Table.FirstN(tableData,1)
in
#"Kept First Rows"

This does not:

let
Source = OData.Feed("https://MYIP/odata", null, [Implementation="2.0"]),
#"Top_function (NumberToReturn as number) as table" = Source{[Name="Top",Signature="function (NumberToReturn as number) as table"]},
Data = #"Top_function (NumberToReturn as number) as table"[Data],
#"Invoked FunctionData" = Data(1)
in
#"Invoked FunctionData"

In the web API they both generate exactly the same data - confirmed by fiddler on both requests.

The error is:

DataSource.Error: OData: Invalid JSON. Unexpected end of input reached while processing a JSON string value.
Details:
DataSourceKind=OData

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

---

let
Source = OData.Feed("https://MYIP/odata", null, [Implementation="2.0"]),
#"Top_function (NumberToReturn as number) as table" = Source{[Name="Top",Signature="function (NumberToReturn as number) as table"]},
Data = #"Top_function (NumberToReturn as number) as table"[Data],
#"Invoked FunctionData" = Data(1)
in
#"Invoked FunctionData"

---

By my test step by step, I'm afraid that the error may caused by the #"Top_function (NumberToReturn as number) as table"  and Data(1).

You could try the query below.

let
Source = OData.Feed("http://services.odata.org/V3/Northwind/Northwind.svc/", null, [Implementation="2.0"]),
#"Employees table" = Source{[Name="Employees",Signature="table"]},
#"Data" = #"Employees table" [Data],
#"Invoked FunctionData" = #"Data"{1}
in
#"Invoked FunctionData"

Best  Regards,

Cherry