I defined a workflow in Logic Apps which runs a query and export result to a csv file in blob storage.
However, I receive tiny floats as enumarated number.
For example : the value of the column is 0,000081 but I see it in the csv as “8.1E-05”. ho can avoid this situation?
enter image description here
the JSON call is as below :
<code>{
"type": "Table",
"inputs": {
"from": "@body('SQL_sorgusu_çalıştırın_(V2)_1')?['resultsets']?['Table1']",
"format": "CSV",
"columns": [
{
"value": "@{item()?['Column1']}"
},
{
"value": "@{item()?['Column2']}"
},
{
"value": "@{item()?['COlumn3']}"
},
{
"value": "@{item()?['Column4']}"
},
{
"value": "@{item()?['FloatColumn']}"
},
{
"value": "@{item()?['Column5']}"
},
{
"value": "@{item()?['Column6']}"
}
]
},
"runAfter": {
"SQL_sorgusu_çalıştırın_(V2)_1": [
"SUCCEEDED"
]
}
}
</code>
<code>{
"type": "Table",
"inputs": {
"from": "@body('SQL_sorgusu_çalıştırın_(V2)_1')?['resultsets']?['Table1']",
"format": "CSV",
"columns": [
{
"value": "@{item()?['Column1']}"
},
{
"value": "@{item()?['Column2']}"
},
{
"value": "@{item()?['COlumn3']}"
},
{
"value": "@{item()?['Column4']}"
},
{
"value": "@{item()?['FloatColumn']}"
},
{
"value": "@{item()?['Column5']}"
},
{
"value": "@{item()?['Column6']}"
}
]
},
"runAfter": {
"SQL_sorgusu_çalıştırın_(V2)_1": [
"SUCCEEDED"
]
}
}
</code>
{
"type": "Table",
"inputs": {
"from": "@body('SQL_sorgusu_çalıştırın_(V2)_1')?['resultsets']?['Table1']",
"format": "CSV",
"columns": [
{
"value": "@{item()?['Column1']}"
},
{
"value": "@{item()?['Column2']}"
},
{
"value": "@{item()?['COlumn3']}"
},
{
"value": "@{item()?['Column4']}"
},
{
"value": "@{item()?['FloatColumn']}"
},
{
"value": "@{item()?['Column5']}"
},
{
"value": "@{item()?['Column6']}"
}
]
},
"runAfter": {
"SQL_sorgusu_çalıştırın_(V2)_1": [
"SUCCEEDED"
]
}
}
I also check the options of “Create CSV” but there is no configuration for formatting.