LABEL 'Repetir SN' WebAutomation.LaunchChrome.LaunchChromeNoWait Url: $'''https://www8.receita.fazenda.gov.br/SimplesNacional/aplicacoes.aspx?id=21''' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False Timeout: 60 PiPUserDataFolderMode: WebAutomation.PiPUserDataFolderModeEnum.AutomaticProfile TargetDesktop: $'''{\"DisplayName\":\"Computador local\",\"Route\":{\"ServerType\":\"Local\",\"ServerAddress\":\"\"},\"DesktopType\":\"local\"}''' BrowserInstance=> sitesn WAIT (WebAutomation.WaitForWebPageContent.WebPageToContainText BrowserInstance: sitesn Text: $'''cnpj''') WAIT 3 WebAutomation.PopulateTextField.PopulateTextFieldUsePhysicalKeyboard BrowserInstance: sitesn Control: appmask['Web Page \'h ... aspx?id=21\'']['Input text \'Cnpj\''] Text: cnpj Mode: WebAutomation.PopulateTextMode.Replace UnfocusAfterPopulate: True WaitForPageToLoadTimeout: 60 ON ERROR REPEAT ACTION END WebAutomation.Click.Click BrowserInstance: sitesn Control: appmask['Web Page \'h ... aspx?id=21\'']['Button \'Consultar\' 3'] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True WaitForPageToLoadTimeout: 60 MousePositionRelativeToElement: WebAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 # Ia fazer para se der erro por ser de robo refazer, mas como faz um por vez nao vai dar IF (WebAutomation.IfWebPageContains.WebPageContainsText BrowserInstance: sitesn Text: $'''Inválido''') THEN WebAutomation.CloseWebBrowser BrowserInstance: sitesn SET ERRO TO $'''SIM''' EXIT FUNCTION END IF (WebAutomation.IfWebPageContains.WebPageContainsText BrowserInstance: sitesn Text: $'''Impedido por proteção''') THEN MouseAndKeyboard.SendKeys.FocusAndSendKeys TextToSend: $'''{F5}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False WebAutomation.CloseWebBrowser BrowserInstance: sitesn WAIT 5 GOTO 'Repetir SN' END WAIT (WebAutomation.WaitForWebPageContent.WebPageToContainText BrowserInstance: sitesn Text: $'''mais''') IF (WebAutomation.IfWebPageContains.WebPageContainsText BrowserInstance: sitesn Text: $'''Optante pelo Simples Nacional''') THEN Excel.WriteToExcel.WriteCell Instance: planilha_base Value: $'''SIM''' Column: $'''T''' Row: linhaatual END IF (WebAutomation.IfWebPageContains.WebPageContainsText BrowserInstance: sitesn Text: $'''NÃO optante''') THEN Excel.WriteToExcel.WriteCell Instance: planilha_base Value: $'''NÃO''' Column: $'''T''' Row: linhaatual END WebAutomation.ExtractData.ExtractSingleValue BrowserInstance: sitesn ExtractionParameters: {[$'''html > body > form > div:eq(2) > main > div > div > div:eq(1) > div:eq(1) > div > div > iframe > html > body > div > div:eq(1) > div:eq(1) > div:eq(1) > span:eq(0)''', $'''Own Text''', $''''''] } TimeoutInSeconds: 60 ExtractedData=> snopt WebAutomation.CloseWebBrowser BrowserInstance: sitesn # [ControlRepository][PowerAutomateDesktop] { "ControlRepositorySymbols": [ { "IgnoreImagesOnSerialization": false, "Repository": "{\r\n \"Screens\": [\r\n {\r\n \"Controls\": [\r\n {\r\n \"AutomationProtocol\": \"uia3\",\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Input text\",\r\n \"InstanceId\": \"c5270cc3-11d3-40f0-ae9e-0c5a6ac8bbec\",\r\n \"Name\": \"Input text 'Cnpj'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"IsDisabledAttribute\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"IsDisabledAttribute\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"IsDisabledAttribute\": false,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"IsDisabledAttribute\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Body '//