The updateFile()
For information on loading and using files, see the
Lookup Files documentation page.
Below is the syntax for the
updateFile()
updateFile(
fileName : string!
name : string!
changedRows : [ [ string! ] ! ] !
headers : [ string! ] !
columnChanges : [ ColumnChange! ] !
limit : integer
offset : integer
) : UploadedFileSnapshot!
Below is an example of how this mutation field might be used:
Show:
Raw Mac OS or Linux (curl) Mac OS or Linux (curl) One-line Windows Cmd and curl Windows Powershell and curl Perl Python Node.js
Raw mutation {
updateFile(
fileName : "somefile.csv" ,
name : "humio" ,
changedRows : [ "some" , "thing" ] ,
headers : [ "my-header" ] ,
columnChanges : [ { changeKind : Remove, index : 1 } ]
)
{ lines }
} Mac OS or Linux (curl) curl -v -X POST $YOUR_LOGSCALE_URL/graphql \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d @- << EOF
{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}
EOFMac OS or Linux (curl) One-line curl -v -X POST $YOUR_LOGSCALE_URL/graphql \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d @- << EOF
{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}
EOFWindows Cmd and curl curl -v -X POST $YOUR_LOGSCALE_URL/graphql ^
-H "Authorization: Bearer $TOKEN" ^
-H "Content-Type: application/json" ^
-d @'{"query" : "mutation { ^
updateFile( ^
fileName: \"somefile.csv\", ^
name: \"humio\", ^
changedRows: [ \"some\", \"thing\"], ^
headers: [ \"my-header\" ], ^
columnChanges: [ { changeKind: Remove, index: 1 } ] ^
) ^
{ lines } ^
}" ^
} 'Windows Powershell and curl curl.exe -X POST
-H "Authorization: Bearer $TOKEN "
-H "Content-Type: application/json"
-d '{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}'
"$YOUR_LOGSCALE_URL /graphql" Perl
use HTTP::Request;
use LWP;
my $INGEST_TOKEN = "TOKEN" ;
my $uri = '$YOUR_LOGSCALE_URL/graphql' ;
my $json = '{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}' ;
my $req = HTTP::Request->new("POST" , $uri );
$req->header("Authorization" => "Bearer $TOKEN" );
$req->header("Content-Type" => "application/json" );
$req->content( $json );
my $lwp = LWP::UserAgent->new;
my $result = $lwp->request( $req );
print $result->{"_content" },"\n" ;Python
import requests
url = '$YOUR_LOGSCALE_URL/graphql'
mydata = r'''{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}'''
resp = requests.post(url,
data = mydata,
headers = {
"Authorization" : "Bearer $TOKEN" ,
"Content-Type" : "application/json"
}
)
print (resp.text)Node.js const https = require ('https' );
const data = JSON .stringify (
{"query" : "mutation {
updateFile(
fileName: \"somefile.csv\",
name: \"humio\",
changedRows: [ \"some\", \"thing\"],
headers: [ \"my-header\" ],
columnChanges: [ { changeKind: Remove, index: 1 } ]
)
{ lines }
}"
}
);
const options = {
hostname : '$YOUR_LOGSCALE_URL/graphql' ,
path : '/graphql' ,
port : 443 ,
method : 'POST' ,
headers : {
'Content-Type' : 'application/json' ,
'Content-Length' : data.length ,
Authorization : 'BEARER ' + process.env .TOKEN ,
'User-Agent' : 'Node' ,
},
};
const req = https.request (options, (res ) => {
let data = '' ;
console .log (`statusCode: ${res.statusCode} ` );
res.on ('data' , (d ) => {
data += d;
});
res.on ('end' , () => {
console .log (JSON .parse (data).data );
});
});
req.on ('error' , (error ) => {
console .error (error);
});
req.write (data);
req.end ();Example Responses Show:
Success (HTTP Response Code 200 OK)
Success (HTTP Response Code 200 OK) {
"data" : {
"updateFile" : {
"lines" : "4"
}
}
}
For ColumnChange , there
are a couple of parameters that may be given. Below is a list of
them along with a description of each:
The returned datatype
UploadedFileSnapshot has
several parameters. Below is a list of them along with a
description of each:
Table: UploadedFileSnapshot
Parameter Type Required Default Stability Description Some arguments may be required, as indicated in the Required Table last updated: Mar 27, 2025 filterStringstring Long-TermAny string on which to filter the data. headers[string] yes Long-TermThe headers for the uploaded snapshot file. limitinteger yes Long-TermThe file upload limit. lines[string] yes Long-TermThe contents of the file in the form of a list of lines, with each line being itself a list of column values. When the file is empty or nothing matches filterString , then [] nameAndPathFileNameAndPathyes Long-TermThe name and path of the uploaded snapshot file. See FileNameAndPath offsetinteger yes Long-TermThis is the offset supplied to a file query. For a new or updated file, this is always 0. resourcestring Short-TermThe resource identifier for the file. totalLinesCountlong yes Long-TermThe total number of lines in the uploaded snapshot file.
