As a Manual User, I open Web Excel, Insert EFP Record Add-in, log in there, and open reports with some data from the initial source. Once the report is opened, I can see in excel data as well as I can see once I open the same report in https://epicor.performancecanvas.com/
But once I follow the same steps automatically (using https://app.virtuoso.qa/) Reports cannot be opened and No data found message is shown
The question is, how can I avoid security checking for virtuoso bots' API
{"d":{"__type":"Microsoft.Office.Excel.WebUI.EwaResult","Errors":[],"Result":null,"ClientUdfCallInfo":null,"SessionId":"15.DB5PEPF000117F41.A108.1.U36.d068c451-2f34-45ab-a091-c30f8a97bf4e14.5.en-US5.en-US16.100320026447c34e1.S24.4eD5WQGBl0ex/Ja+QbsJYw==16.16.0.16111.4230614.5.en-US5.en-US1.M1.N0.1.S","StateId":8,"LatestClientInstantaneousChangeRequestId":null,"LatestClientInstantaneousInfo":{"BlockDataChangeRequestId":null,"SpdChangeRequestId":null},"MergeCount":null,"WorkbookCoauthVersion":{"DocId":"11_E60897F41BE170836B02CE998F75CCDC64E183C8","Xluid":"fca9f8a9-885d-46c3-96f5-ba521c7b9570","Xrevid":3},"RequestId":null,"SecondsBeforeNextPoll":20,"TransientEditSessionToken":"KM9s1H6AGUekr73Vko1e+A==","RequestTelemetryData":{"EcsOperationDuration":0,"EcsRequestDuration":1,"WfeRequestDuration":6,"TimeFromLastEcsFreeze":84983241,"DuringLoadOnDemand":false},"EditSessionHasMultipleCoauthors":false,"IsUsingOcs":false,"EditSessionIsDirty":false,"RemainingWorkbookSize":104847868,"LoadOnDemandOccurrenceCounter":0,"NamedSheetViewConversionVersion":0,"TemporarySheetViewVersion":0,"OperationStates":null,"DoesNotChangesWorkbook":true,"CollaborationResult":{"CollaborationState":{"UserListVersion":2,"CollabStateId":8},"Users":null},"WorkbookMetadataResult":{"WorkbookMetadataState":{"MetadataVersion":4,"ServerEventVersion":2},"Metadata":{"Sheets":null,"SheetChanges":null,"HidePivotFieldList":false,"FieldListForceOnTop":false,"ServerEventMetadataList":null,"WebExtensions":null,"HasSurveys":false,"SurveyTitle":null,"HasVbaDigSig":false,"HasCommentEver":false,"HasFinanceLinkedEntityEver":false,"HasUntrustedImageUrlEver":false,"IsReadOnlyRecommended":false,"CalcMode":0,"WorkbookFileName":null,"StructureLocked":false,"EditDocInClientUrl":null,"DirectInvokeDAVUrl":null,"DownloadACopyUrl":null,"AppliedPolicyLabelId":null,"ExternalLinksStateId":0,"HasAutoRefreshableLinkedEntityDomainsEver":false,"NamedCellStylesStateId":0,"LineageVersion":0,"BreadcrumbFolderUrl":null,"BreadcrumbFolderName":null,"ConditionalFormattingRulesStateId":0,"HasLinkedDataType":false,"HasWolframDataType":false,"ShouldTriggerLineageCalloutOnMerge":false,"PowerQueryStateId":0,"RichDataClassificationLabelStateId":0,"LinkedEntityAsyncRefreshStateId":0}},"ServerEvents":null,"GridBlockResponsePairs":null,"ClientStopwatchId":null,"ServerCorrelationId":"0b34d9c8-af7a-40a8-980b-1462b8cddbce","ReportCalcState":false,"CalcComplete":false,"HasDirtyDataSource":false,"SheetProcessedData":null,"DepartableWebMethodOperationCompleted":true}}
{"ClientUdfCallInfo":null,"CollaborationResult":null,"DoesNotChangesWorkbook":false,"EditSessionHasMultipleCoauthors":false,"EditSessionIsDirty":false,"Errors":null,"LatestClientInstantaneousChangeRequestId":null,"LatestClientInstantaneousInfo":null,"LoadOnDemandOccurrenceCounter":0,"NamedSheetViewConversionVersion":0,"OperationStates":null,"RemainingWorkbookSize":null,"RequestId":null,"RequestTelemetryData":null,"Result":null,"SecondsBeforeNextPoll":0,"SessionId":null,"StateId":0,"TemporarySheetViewVersion":0,"TransientEditSessionToken":null,"WorkbookMetadataResult":null}