Skip to main content

In many of the tutorials for dealing with specific types of APIs reference is made to internal variables like {TX_CurrentPage} and others that can be leveraged to implement things like pagination. As far as I can find there does not seem to be a list of such items and what they do. Could this be made available?

 

Hi @rory.smith 

The variables {TX_NextPage} and {TX_CurrentPage} are covered here under Pagination section

Please confirm if these are the variables you are referring to


Hi @Christian Hauggaard ,

 

thanks - I think it would be more clear to have a separate section listing the variables and their specific meaning. While I can apply this tutorial, I would prefer to know exactly what these variables (and any future new ones) mean.


@rory.smith thanks for the feedback we will take this into account going forward


@rory.smith 

I added the part about builtin options Friday afternoon. There is not supposed to be more than these, but if new ones is added, I will make sure to add it to the guide and what their purpose is.


Hi @Thomas Lind, would it be possible to document the data-type names and conversions for the REST data source? 

For example, I am trying to override datatypes on a data source in ODX to make all string type fields nvarchar(max). Using datatype contains(ignore case) = ‘string’ does not work.

Would be great to know what the datatypes are called, and what they translate to in data-lake and SQL. 

I realize that override datatypes only takes effect if you delete the data files from the storage blob. string to varchar(max) works as expected. 

 

Kind regards,

Andrew


Reply