C# BatchUpdateDocumentRequest ReplaceAllText Google Docs Api

Question

I'm trying to update/replace a given text at a Google Docs Template.

The code i've tried so far:

DriveService service = GetDriveService();

var firstname = "Firstname";
var lastname = "Lastname";

BatchUpdateDocumentRequest body = new BatchUpdateDocumentRequest();

List<Request> requests = new List<Request>();

var repl = new Request();
var substrMatchCriteria = new SubstringMatchCriteria();
var replaceAlltext = new ReplaceAllTextRequest();
replaceAlltext.ReplaceText = firstname + "." + lastname;
substrMatchCriteria.Text = "vorname.nachname";
replaceAlltext.ContainsText = substrMatchCriteria;
repl.ReplaceAllText = replaceAlltext;

requests.Add(repl);
body.Requests = requests;


//Batch update Request requires 3 Parameters
DocumentsResource.BatchUpdateRequest bUpdate = new DocumentsResource.BatchUpdateRequest(service, body, "160NinGjrmshSga8fWkCFRwApV0FTL1BiJCidH7A1yFw");
bUpdate.Execute(); // The Exception is raised here

the DocumentsResource.BatchUpdateRequestrequires the following parameters:

Following error occurs:

Google.GoogleApiException: "Not Found"

JsonReaderException: Error parsing NaN value. Path '', line 1, position 1.

Diese Ausnahme wurde ursprünglich bei dieser Aufrufliste ausgelöst:
Newtonsoft.Json.JsonTextReader.ParseNumberNaN(Newtonsoft.Json.ReadType, bool)
Newtonsoft.Json.JsonTextReader.ParseValue()
Newtonsoft.Json.JsonTextReader.Read()
Newtonsoft.Json.JsonReader.ReadForType(Newtonsoft.Json.Serialization.JsonContract, bool)
Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(Newtonsoft.Json.JsonReader, System.Type, bool)
Newtonsoft.Json.JsonSerializer.DeserializeInternal(Newtonsoft.Json.JsonReader, System.Type)
Newtonsoft.Json.JsonConvert.DeserializeObject(string, System.Type, Newtonsoft.Json.JsonSerializerSettings)
Google.Apis.Services.BaseClientService.DeserializeError(System.Net.Http.HttpResponseMessage)

I took the documentId from the Document path

Also the file is present using a files.list:

What am I missing/doing wrong?

Willing to bet thats not the file id. Do a files.list from google drive api and find the corect file id. Also whats in GetDriveService — Linda Lawton - DaImTo
– Linda Lawton - DaImTo, Commented Feb 5, 2020 at 12:47
Added the files.list Request, which represents the given fileId — Martin Stundner
– Martin Stundner, Commented Feb 5, 2020 at 13:04
The method BatchUpdateRequest expects only two parameters - the request and the document Id, see here for a sample. — ziganotschka
– ziganotschka, Commented Feb 5, 2020 at 14:18
The third parameter is the OPTIONAL field writeControl. The only expected parameters are the documentId and the requests. I do not know what your variable service is but it is unlikely to be one of the required parameters. I assume that it is rather the resource to which you want to apply the batch request. Then it should be something like service.BatchUpdateRequest(body, "160NinGjrmshSga8fWkCFRwApV0FTL1BiJCidH7A1yFw"); I recommend you to test your request with the Try it API before C# implementation — ziganotschka
– ziganotschka, Commented Feb 7, 2020 at 11:30

Francesco · Accepted Answer · 2022-01-04 08:52:53Z

First, you can try to generalize the GetService method, I did it because I use various scopes

public static object GetService(apiType api = apiType.GDrive)
    {
        UserCredential credential;
        
        string CSPath = HostingEnvironment.MapPath("~/MyFolder/");

        using (var stream = new FileStream(Path.Combine(CSPath, "client_secret.json"), FileMode.Open, FileAccess.Read))
        {

            string FolderPath = CSPath;

            string FilePath = Path.Combine(FolderPath, "DriveServiceCredentials.json");

            credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
                GoogleClientSecrets.Load(stream).Secrets,
                Scopes,
                "user",
                CancellationToken.None,
                new FileDataStore(FilePath, true)
                ).Result;

        }
        
        if (api == apiType.GDocs)
        {
            DocsService docsService = new DocsService(new BaseClientService.Initializer()
            {
                HttpClientInitializer = credential,
                ApplicationName = MyApplicationName,
            });
            return docsService;
        }
        else
        {
            DriveService driveService = new DriveService(new BaseClientService.Initializer()
            {
                HttpClientInitializer = credential,
                ApplicationName = MyApplicationName
            });
            return driveService;
        }

    }

then you can try something like this:

public static void EditDoc(string fileId, Dictionary<string, string> textToReplace)
    {
        DocsService service = (DocsService)GetService(apiType.GDocs);
        
        List<Request> requests = new List<Request>();

        foreach (var text in textToReplace)
        {
            var repl = new Request();
            var substrMatchCriteria = new SubstringMatchCriteria();
            var replaceAlltext = new ReplaceAllTextRequest();

            replaceAlltext.ReplaceText = text.Value;
            substrMatchCriteria.Text = text.Key;

            replaceAlltext.ContainsText = substrMatchCriteria;
            repl.ReplaceAllText = replaceAlltext;

            requests.Add(repl);
        }

        BatchUpdateDocumentRequest body = new BatchUpdateDocumentRequest { Requests = requests };
        
        service.Documents.BatchUpdate(body, fileId).Execute();

    }

I used this document as a reference https://developers.google.com/docs/api/how-tos/merge for some reason Google haven't translated it in C#...

Collectives™ on Stack Overflow

C# BatchUpdateDocumentRequest ReplaceAllText Google Docs Api

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related