How can we find DOC is empty. In GSuite

Help
,
1

Hello UIpath Family can I get to know DOC is empty I have one DOC file in my google account how can we get it now that the file is empty?

I was struck two days, I read the data and stored it in one variable example (Body) if the doc is empty then it won’t go for the workflow but it empty also it’s going to the workflow I don’t know why I use this code NOT STRING.ISNULLOREMPTY(BODY)

I hope I will get the replay from anyone

Thanks
Chethan P

2

@copy_writes - Is it google sheet or just some doc like pdf, jpeg, etc etc…?

You can check like this…

image
image1798×657 35 KB

Please take a note on For Each type…its

Google.apis.drive.v3.data.file

In the write line …when you type item. this gives your plenty of options to choose. For you needs you pick Size. If its 0 then the doc is empty. In my case it is 844315 bytes(Result displayed on the output panel)

image
image925×364 51 KB

1 Like
3

I have a dought How you peoples get to know all these new codes and all if you don’t mind, please guide me @prasath17 its help to me in feature

Thanks
Chethan P

1 Like
4

hi @copy_writes … Sure…whatever I know I will list here…

  1. When you hit ctrl+K to in the ‘Result’ it will save the variable as Google.Apis.Drive.v3.data.File

image
image1281×486 87.5 KB

  1. When you use same variable type in For Each…Note…Instead of Array…you just have to use Google.Apis.Drive.v3.data.File.

  2. When you use the right variable type, whenever you use the row variable say Item and . it will give all the various options tied with that variable type.

In this case, I initially right click at File and Folders activity and choose help. It t took me to Uipath Docs page where you can find a link to google apis options.

Key links…

Most of the time, if I dont know i do a extensive search through the UiPath Forum and read and take notes of the any formula (which I save it to my one note)…

1 Like
5

Thanks You very much @prasath17 its really helps me

Thanks
Chethan P

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.