protected override string GetQuery(CodeActivityContext context)
{
long recordId = TableRecordID.Get(context);
string title = Title.Get(context);
DateTime dueDate = DueDate.Get(context);
string statusId = StatusID.Get(context);
string titleStr = string.Empty;
if (!string.IsNullOrWhiteSpace(title))
{
titleStr = string.Format("title: {0}", title.ToQueryValue());
}
string dueDateStr = string.Empty;
if (dueDate != null && dueDate != DateTime.MinValue)
{
dueDateStr = string.Format("due_date: {0}", dueDate.ToQueryValue());
}
string statusStr = string.Empty;
if (!string.IsNullOrWhiteSpace(statusId))
{
statusStr = string.Format("statusId: \"{0}\"", statusId);
}
return(string.Format(UpdateTableRecordQuery, recordId, titleStr, dueDateStr, statusStr));
}
protected override string GetQuery(CodeActivityContext context)
{
long id = TableRecordID.Get(context);
string fieldId = FieldID.Get(context);
object fieldValue = Value.Get(context);
return(string.Format(SetTableRecordFieldValueQuery, id, fieldId, fieldValue.ToQueryValue()));
}
protected override string GetQuery(CodeActivityContext context)
{
long recordId = TableRecordID.Get(context);
return(string.Format(GetTableRecordQuery, recordId));
}
protected override void Execute(CodeActivityContext context)
{
System.Net.WebRequest req = System.Net.WebRequest.Create("https://app.pipefy.com/queries");
req.Proxy.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
req.Timeout = 120000;
req.Headers.Add("authorization", "Bearer " + Bearer.Get(context));
req.ContentType = "application/json";
req.Method = "POST";
byte[] bytes = System.Text.Encoding.UTF8.GetBytes("{ \"query\": \"{ table_record(id: " + TableRecordID.Get(context) + ") { assignees { id name } created_at created_by { id name } due_date finished_at id labels { id name } parent_relations { name source_type } record_fields { array_value date_value datetime_value filled_at float_value name required updated_at value } summary { title value } table { id } title updated_at url } }\" }");
req.ContentLength = bytes.Length;
System.IO.Stream os = req.GetRequestStream();
os.Write(bytes, 0, bytes.Length);
os.Close();
System.Net.WebResponse resp = req.GetResponse();
System.IO.StreamReader sr = new System.IO.StreamReader(resp.GetResponseStream());
JArray array = new JArray();
JObject joResponse = JObject.Parse(sr.ReadToEnd());
Return.Set(context, joResponse.ToString());
}
protected override void Execute(CodeActivityContext context)
{
System.Net.WebRequest req = System.Net.WebRequest.Create("https://app.pipefy.com/queries");
req.Proxy.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
req.Timeout = 120000;
req.Headers.Add("authorization", "Bearer " + Bearer.Get(context));
req.ContentType = "application/json";
req.Method = "POST";
byte[] bytes = System.Text.Encoding.UTF8.GetBytes("{ \"query\": \"mutation { setTableRecordFieldValue(input: { table_record_id: \"" + TableRecordID.Get(context) + "\" field_id: \"" + FieldRecordID.Get(context) + "\" value: \"" + FieldValue.Get(context) + "\"}) { table_record { id title } table_record_field { value } } }\" }");
req.ContentLength = bytes.Length;
System.IO.Stream os = req.GetRequestStream();
os.Write(bytes, 0, bytes.Length);
os.Close();
System.Net.WebResponse resp = req.GetResponse();
System.IO.StreamReader sr = new System.IO.StreamReader(resp.GetResponseStream());
JArray array = new JArray();
JObject joResponse = JObject.Parse(sr.ReadToEnd());
Return.Set(context, joResponse.ToString());
}
