How to read a file in server with google-apps-script?
I need to recover a .csv file located on a local server that contains information about the silos, and which will regenerate regularly.
I then copy the information in a google sheet so that I can process it in my application. I use google-apps-script.
I have already done a script to retrieve information from the CSV file that works but only from a file store in the google drive.
The problem is that I would like to recover my file directly from a server (which I know the ip address, and the destination path.) Instead of recovering it in a drive.
I look for google script functions to do that a good part of the after, but I found nothing conclusive. I'm asking you if you ever had to do that.
Is there a google-apps-script function to do what I want?
Have a good evening.
Cordially.
google-apps-script server
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
add a comment |
I need to recover a .csv file located on a local server that contains information about the silos, and which will regenerate regularly.
I then copy the information in a google sheet so that I can process it in my application. I use google-apps-script.
I have already done a script to retrieve information from the CSV file that works but only from a file store in the google drive.
The problem is that I would like to recover my file directly from a server (which I know the ip address, and the destination path.) Instead of recovering it in a drive.
I look for google script functions to do that a good part of the after, but I found nothing conclusive. I'm asking you if you ever had to do that.
Is there a google-apps-script function to do what I want?
Have a good evening.
Cordially.
google-apps-script server
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22
add a comment |
I need to recover a .csv file located on a local server that contains information about the silos, and which will regenerate regularly.
I then copy the information in a google sheet so that I can process it in my application. I use google-apps-script.
I have already done a script to retrieve information from the CSV file that works but only from a file store in the google drive.
The problem is that I would like to recover my file directly from a server (which I know the ip address, and the destination path.) Instead of recovering it in a drive.
I look for google script functions to do that a good part of the after, but I found nothing conclusive. I'm asking you if you ever had to do that.
Is there a google-apps-script function to do what I want?
Have a good evening.
Cordially.
google-apps-script server
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
I need to recover a .csv file located on a local server that contains information about the silos, and which will regenerate regularly.
I then copy the information in a google sheet so that I can process it in my application. I use google-apps-script.
I have already done a script to retrieve information from the CSV file that works but only from a file store in the google drive.
The problem is that I would like to recover my file directly from a server (which I know the ip address, and the destination path.) Instead of recovering it in a drive.
I look for google script functions to do that a good part of the after, but I found nothing conclusive. I'm asking you if you ever had to do that.
Is there a google-apps-script function to do what I want?
Have a good evening.
Cordially.
google-apps-script server
google-apps-script server
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
asked Nov 12 '18 at 16:17
Alexandre BerthetAlexandre Berthet
61
61
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22
add a comment |
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53266126%2fhow-to-read-a-file-in-server-with-google-apps-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53266126%2fhow-to-read-a-file-in-server-with-google-apps-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Look in utilities.
– Cooper
Nov 12 '18 at 16:31
Possible duplicate of Importing multiple CSV files to google sheets with Google Script
– Tedinoz
Nov 12 '18 at 18:22