-
Notifications
You must be signed in to change notification settings - Fork 0
/
GetNegativeBalanceAcounts-Apis.xaml
218 lines (218 loc) · 16.6 KB
/
GetNegativeBalanceAcounts-Apis.xaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
<Activity mc:Ignorable="sap sap2010" x:Class="GetNegativeBallanceAcounts" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:njl="clr-namespace:Newtonsoft.Json.Linq;assembly=Newtonsoft.Json" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=mscorlib" xmlns:sco="clr-namespace:System.Collections.ObjectModel;assembly=mscorlib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data.Common" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<x:Members>
<x:Property Name="OUT_outputFile" Type="OutArgument(x:String)" />
</x:Members>
<mva:VisualBasic.Settings>
<x:Null />
</mva:VisualBasic.Settings>
<sap:VirtualizedContainerService.HintSize>1675,2761</sap:VirtualizedContainerService.HintSize>
<sap2010:WorkflowViewState.IdRef>GetNegativeBallanceAcounts_1</sap2010:WorkflowViewState.IdRef>
<TextExpression.NamespacesForImplementation>
<scg:List x:TypeArguments="x:String" Capacity="48">
<x:String>System.Activities</x:String>
<x:String>System.Activities.Statements</x:String>
<x:String>System.Activities.Expressions</x:String>
<x:String>System.Activities.Validation</x:String>
<x:String>System.Activities.XamlIntegration</x:String>
<x:String>Microsoft.VisualBasic</x:String>
<x:String>Microsoft.VisualBasic.Activities</x:String>
<x:String>System</x:String>
<x:String>System.Collections</x:String>
<x:String>System.Collections.Generic</x:String>
<x:String>System.Data</x:String>
<x:String>System.Diagnostics</x:String>
<x:String>System.Drawing</x:String>
<x:String>System.IO</x:String>
<x:String>System.Linq</x:String>
<x:String>System.Net.Mail</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>System.Windows.Markup</x:String>
<x:String>Newtonsoft.Json.Linq</x:String>
<x:String>Newtonsoft.Json</x:String>
<x:String>System.Xml.Serialization</x:String>
<x:String>UiPathTeam.JSONUtilities</x:String>
<x:String>System.Collections.ObjectModel</x:String>
<x:String>System.Activities.DynamicUpdate</x:String>
<x:String>System.Runtime.Serialization</x:String>
<x:String>System.Reflection</x:String>
<x:String>System.Dynamic</x:String>
<x:String>System.ComponentModel</x:String>
<x:String>System.Collections.Specialized</x:String>
</scg:List>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<sco:Collection x:TypeArguments="AssemblyReference">
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
<AssemblyReference>Newtonsoft.Json</AssemblyReference>
<AssemblyReference>System.ServiceModel</AssemblyReference>
<AssemblyReference>System.ComponentModel.Composition</AssemblyReference>
<AssemblyReference>UiPathTeam.JSONUtilities.Activities</AssemblyReference>
<AssemblyReference>UiPathTeam.JSONUtilities</AssemblyReference>
<AssemblyReference>Microsoft.Bcl.AsyncInterfaces</AssemblyReference>
<AssemblyReference>System.ValueTuple</AssemblyReference>
<AssemblyReference>System.Memory</AssemblyReference>
<AssemblyReference>NPOI</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Formatters</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Primitives</AssemblyReference>
<AssemblyReference>System.Private.ServiceModel</AssemblyReference>
<AssemblyReference>System.Private.DataContractSerialization</AssemblyReference>
<AssemblyReference>UiPath.System.Activities.Design</AssemblyReference>
<AssemblyReference>System.Console</AssemblyReference>
<AssemblyReference>System.ComponentModel.TypeConverter</AssemblyReference>
<AssemblyReference>System.ComponentModel</AssemblyReference>
<AssemblyReference>System.Private.Uri</AssemblyReference>
<AssemblyReference>System.Configuration.ConfigurationManager</AssemblyReference>
<AssemblyReference>System.Security.Permissions</AssemblyReference>
<AssemblyReference>System.Memory.Data</AssemblyReference>
<AssemblyReference>UiPath.Workflow</AssemblyReference>
<AssemblyReference>System.ObjectModel</AssemblyReference>
<AssemblyReference>System.Reflection.Metadata</AssemblyReference>
<AssemblyReference>System.Reflection.DispatchProxy</AssemblyReference>
<AssemblyReference>netstandard</AssemblyReference>
</sco:Collection>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="GetNegativeBallanceAcounts" sap:VirtualizedContainerService.HintSize="554,2696" sap2010:WorkflowViewState.IdRef="Sequence_1">
<Sequence.Variables>
<Variable x:TypeArguments="x:String" Name="baseUrl" />
<Variable x:TypeArguments="x:Int32" Name="statusCode" />
<Variable x:TypeArguments="x:String" Name="result" />
<Variable x:TypeArguments="njl:JArray" Name="accounts" />
<Variable x:TypeArguments="x:String" Name="loginResult" />
<Variable x:TypeArguments="x:Int32" Name="loginStatusCode" />
<Variable x:TypeArguments="njl:JObject" Name="loginObj" />
<Variable x:TypeArguments="x:String" Name="filter" />
<Variable x:TypeArguments="sd:DataTable" Name="accountsDt" />
<Variable x:TypeArguments="x:String" Name="pathCSV">
<Variable.Default>
<mva:VisualBasicValue x:TypeArguments="x:String" ExpressionText="Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\_WFOLDER\POC-DEMOS\DEMO_TS_AzureDevOps\Output\accounts2.csv"" />
</Variable.Default>
</Variable>
<Variable x:TypeArguments="njl:JArray" Name="accountsObj" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:GetRobotAsset TimeoutMS="{x:Null}" AssetName="UiBank API Endpoint" DisplayName="Get Endpoint" FolderPath="Shared" sap:VirtualizedContainerService.HintSize="512,137" sap2010:WorkflowViewState.IdRef="GetRobotAsset_1">
<ui:GetRobotAsset.Value>
<OutArgument x:TypeArguments="x:String">[baseUrl]</OutArgument>
</ui:GetRobotAsset.Value>
</ui:GetRobotAsset>
<Switch x:TypeArguments="x:String" DisplayName="Switch" Expression="[baseUrl]" sap:VirtualizedContainerService.HintSize="512,138" sap2010:WorkflowViewState.IdRef="Switch`1_2">
<Switch.Default>
<Assign sap:VirtualizedContainerService.HintSize="262,61.3333333333333" sap2010:WorkflowViewState.IdRef="Assign_3">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[filter]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">
<Literal x:TypeArguments="x:String" Value="" />
</InArgument>
</Assign.Value>
</Assign>
</Switch.Default>
<Assign x:Key="https://uibank-api.uipath.com/api" sap:VirtualizedContainerService.HintSize="262,60" sap2010:WorkflowViewState.IdRef="Assign_2">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[filter]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">["{"+Chr(34)+"where"+Chr(34)+":{" +Chr(34) +"balance"+Chr(34)+":{"+Chr(34)+"lt"+Chr(34)+":0}}}"]</InArgument>
</Assign.Value>
</Assign>
</Switch>
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="512,61" sap2010:WorkflowViewState.IdRef="WriteLine_2" Text="[baseUrl]" />
<ui:HttpClient Body="{x:Null}" ConsumerKey="{x:Null}" ConsumerSecret="{x:Null}" ContinueOnError="{x:Null}" OAuth1Token="{x:Null}" OAuth1TokenSecret="{x:Null}" OAuth2Token="{x:Null}" Password="{x:Null}" ResourcePath="{x:Null}" ResponseHeaders="{x:Null}" SecureClientCertificatePassword="{x:Null}" SecurePassword="{x:Null}" Username="{x:Null}" AcceptFormat="JSON" BodyFormat="application/json" ClientCertificate="[Nothing]" ClientCertificatePassword="[Nothing]" DisplayName="Login Request" EnableSSLVerification="True" EndPoint="[baseUrl + "/users/login"]" sap:VirtualizedContainerService.HintSize="512,57" sap2010:WorkflowViewState.IdRef="HttpClient_3" Method="POST" Result="[loginResult]" StatusCode="[loginStatusCode]" TimeoutMS="6000">
<ui:HttpClient.Attachments>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.Attachments>
<ui:HttpClient.Cookies>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.Cookies>
<ui:HttpClient.Headers>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.Headers>
<ui:HttpClient.Parameters>
<InArgument x:TypeArguments="x:String" x:Key="username">admin</InArgument>
<InArgument x:TypeArguments="x:String" x:Key="password">Password</InArgument>
</ui:HttpClient.Parameters>
<ui:HttpClient.UrlSegments>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.UrlSegments>
</ui:HttpClient>
<ui:DeserializeJson x:TypeArguments="njl:JObject" DisplayName="Deserialize JSON" sap:VirtualizedContainerService.HintSize="512,60" sap2010:WorkflowViewState.IdRef="DeserializeJson`1_5" JsonObject="[loginObj]" JsonString="[loginResult]" />
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="512,61" sap2010:WorkflowViewState.IdRef="WriteLine_4" Text="["Login Status Code" + loginStatusCode.ToString + Environment.NewLine + "Login Object: " + loginObj.ToString]" />
<ui:HttpClient Body="{x:Null}" ConsumerKey="{x:Null}" ConsumerSecret="{x:Null}" ContinueOnError="{x:Null}" OAuth1Token="{x:Null}" OAuth1TokenSecret="{x:Null}" OAuth2Token="{x:Null}" Password="{x:Null}" ResourcePath="{x:Null}" ResponseHeaders="{x:Null}" SecureClientCertificatePassword="{x:Null}" SecurePassword="{x:Null}" Username="{x:Null}" AcceptFormat="JSON" BodyFormat="application/xml" ClientCertificate="[Nothing]" ClientCertificatePassword="[Nothing]" DisplayName="Get Negative Accounts request" EnableSSLVerification="True" EndPoint="[baseUrl + "/accounts"]" sap:VirtualizedContainerService.HintSize="512,57" sap2010:WorkflowViewState.IdRef="HttpClient_2" Method="GET" Result="[result]" StatusCode="[statusCode]" TimeoutMS="6000">
<ui:HttpClient.Attachments>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.Attachments>
<ui:HttpClient.Cookies>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.Cookies>
<ui:HttpClient.Headers>
<InArgument x:TypeArguments="x:String" x:Key="access_token">[loginObj("id").ToString]</InArgument>
</ui:HttpClient.Headers>
<ui:HttpClient.Parameters>
<InArgument x:TypeArguments="x:String" x:Key="filter">[filter]</InArgument>
</ui:HttpClient.Parameters>
<ui:HttpClient.UrlSegments>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</ui:HttpClient.UrlSegments>
</ui:HttpClient>
<If Condition="[statusCode = 200]" sap:VirtualizedContainerService.HintSize="512,1753" sap2010:WorkflowViewState.IdRef="If_1">
<If.Then>
<Sequence sap:VirtualizedContainerService.HintSize="476,1566" sap2010:WorkflowViewState.IdRef="Sequence_2">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:DeserializeJson x:TypeArguments="njl:JArray" DisplayName="Deserialize JSON" sap:VirtualizedContainerService.HintSize="434,60" sap2010:WorkflowViewState.IdRef="DeserializeJson`1_4" JsonObject="[accountsObj]" JsonString="[result]" />
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="434,61" sap2010:WorkflowViewState.IdRef="WriteLine_1" Text="["Status: " + statusCode.ToString + Environment.NewLine + "Accounts: " +accountsObj.ToString]" />
<ui:InvokeWorkflowFile ArgumentsVariable="{x:Null}" ContinueOnError="{x:Null}" DisplayName="Invoke Workflow File" sap:VirtualizedContainerService.HintSize="434,112" sap2010:WorkflowViewState.IdRef="InvokeWorkflowFile_1" UnSafe="False" WorkflowFileName="csv-json.xaml">
<ui:InvokeWorkflowFile.Arguments>
<InArgument x:TypeArguments="x:String" x:Key="inCSVFile">
<mva:VisualBasicValue x:TypeArguments="x:String" ExpressionText="pathCSV" />
</InArgument>
<InArgument x:TypeArguments="x:String" x:Key="inSstrJson">
<mva:VisualBasicValue x:TypeArguments="x:String" ExpressionText="result" />
</InArgument>
</ui:InvokeWorkflowFile.Arguments>
</ui:InvokeWorkflowFile>
<ui:ReadCsvFile DataTable="[accountsDt]" Delimitator="Comma" DisplayName="Read CSV" FilePath="[Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\_WFOLDER\POC-DEMOS\DEMO_TS_AzureDevOps\Output\accounts2.csv"]" sap:VirtualizedContainerService.HintSize="434,153" sap2010:WorkflowViewState.IdRef="ReadCsvFile_1" />
<ui:RemoveDataColumn Column="{x:Null}" ColumnIndex="{x:Null}" ColumnName="userId" DataTable="[accountsDt]" DisplayName="Remove Data Column" sap:VirtualizedContainerService.HintSize="434,185" sap2010:WorkflowViewState.IdRef="RemoveDataColumn_1" />
<ui:RemoveDataColumn Column="{x:Null}" ColumnIndex="{x:Null}" ColumnName="id" DataTable="[accountsDt]" DisplayName="Remove Data Column" sap:VirtualizedContainerService.HintSize="434,185" sap2010:WorkflowViewState.IdRef="RemoveDataColumn_2" />
<ui:AddDataColumn x:TypeArguments="x:Object" AllowDBNull="{x:Null}" AutoIncrement="{x:Null}" Column="{x:Null}" DefaultValue="{x:Null}" MaxLength="{x:Null}" Unique="{x:Null}" ColumnName="email" DataTable="[accountsDt]" DisplayName="Add Data Column" sap:VirtualizedContainerService.HintSize="434,185" sap2010:WorkflowViewState.IdRef="AddDataColumn`1_1" />
<ui:WriteCsvFile AddHeaders="True" DataTable="[accountsDt]" Delimitator="Comma" DisplayName="Write CSV" FilePath="[Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\_WFOLDER\POC-DEMOS\DEMO_TS_AzureDevOps\Output\negativeAccounts2.csv"]" sap:VirtualizedContainerService.HintSize="434,153" sap2010:WorkflowViewState.IdRef="WriteCsvFile_1" ShouldQuote="True" />
<Assign sap:VirtualizedContainerService.HintSize="434,60" sap2010:WorkflowViewState.IdRef="Assign_4">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[OUT_outputFile]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\_WFOLDER\POC-DEMOS\DEMO_TS_AzureDevOps\Output\negativeAccounts2.csv"]</InArgument>
</Assign.Value>
</Assign>
</Sequence>
</If.Then>
</If>
</Sequence>
</Activity>