// this method gets graphic portal info of a product
private async Task <(FMRecordSet GraphicsPortalData, string RecordID)> GetProductGraphicsPortalAndRecordID(int productRecordId)
{
fmServer.SetLayout(productLayout);
var getProductRequest = fmServer.FindRequest(productRecordId);
var getProductResponse = await getProductRequest.Execute();
FMRecord findResultRow = getProductResponse.data.foundSet.records.First();
FMRecordSet graphicsPortalData = null;
foreach (var relatedData in findResultRow.relatedRecordSets)
{
if (!string.IsNullOrEmpty(relatedData.tableLayoutObjectName) && relatedData.tableLayoutObjectName.ToLower() == "graphicsportal")
{
graphicsPortalData = relatedData;
break;
}
}
return(graphicsPortalData, findResultRow.fieldsAndData["RecordID"]);
}
private async Task <FileInfo> GetContainerDataFile(int recordId, string fieldName, int repetitionNumber)
{
int targetRecordId = recordId; // make sure this record has some data in the container field targeted!
string containerField = fieldName;
if (repetitionNumber > 0)
{
// append the repetition number, repeating fields look like this in the returned data
// container_field_repeat(3)": "https://..."
containerField = $"{containerField}({repetitionNumber})";
}
// what layout has a container field on it?
fms.SetLayout("FRUIT_utility");
fms.SetDownloadFolder(@"C:\Users\Public");
Login();
// find the record
var findMyRecord = fms.FindRequest(targetRecordId);
// execute the find
var myData = await findMyRecord.Execute();
// work with the result returned to get the URL of the container data
FMData result = myData.data;
FMRecordSet foundset = result.foundSet;
// there is only one record
FMRecord row = foundset.records.First();
// get the URL from the container field
string url = row.fieldsAndData[containerField];
// get the container data to a file on disk
FileInfo containerDataFile =
await fms.DownloadFileFromContainerField(url, "test_" + RandomString(5, true) + ".jpg");
Logout();
return(containerDataFile);
}
private static void PrintOut(RecordsGetResponse getFindResponse)
{
FMData FMresult = getFindResponse.data;
FMRecordSet FMrecords = FMresult.foundSet;
Console.WriteLine(FMrecords.records.Count + " records found in " + testLayoutDataPortal);
foreach (FMRecord row in FMrecords.records)
{
Console.WriteLine("record id = " + row.recordId);
if (row.relatedRecordSets != null)
{
foreach (FMRecordSet relatedSet in row.relatedRecordSets)
{
Console.WriteLine("has " + relatedSet.records.Count + " related records in " + relatedSet.tableName);
}
}
Console.WriteLine("fields for this record:");
foreach (KeyValuePair <string, string> kv in row.fieldsAndData)
{
Console.WriteLine(kv.Key + " = " + kv.Value);
}
Console.WriteLine();
}
}
private static async Task RunAsync()
{
DateTime start = DateTime.Now;
Console.WriteLine(start.ToString());
int newRecordId = 0;
int newRecordModId = 0;
int emptyRecordId = 0;
// start the connection to FMS, specifying the FMS17 version
var fmserver = new FMS17(server, testAccount, testPassword);
// specify what file to work with
// data from related files will also be available provided
// that there are table occurrences to it in this target file
// and that the account has access to it
fmserver.SetFile(testFile);
// ---------------------------------------------------------------------------------------------------
// authenticate and get the token
token = await fmserver.Authenticate();
if (token.Contains("error"))
{
Console.WriteLine("could not obtain token, quiting");
Console.WriteLine("");
Console.Beep();
Console.WriteLine("Press any key to close this window...");
Console.ReadKey();
Environment.Exit(0);
}
else
{
Console.WriteLine("token recevied = " + token);
}
// ---------------------------------------------------------------------------------------------------
// create an empty record
Console.WriteLine("==> Creating a new empty record...");
// set the layout you want to interact with
// all interactions are done through a layout, layout determines what table and what fields
// basically your context
fmserver.SetLayout(testLayoutData);
var empty = fmserver.NewRecordRequest();
empty.AddScript(ScriptTypes.before, "log", "creating empty record");
var response = await empty.Execute();
if (fmserver.lastErrorCode == 0)
{
emptyRecordId = response;
Console.WriteLine("new empty record = " + emptyRecordId.ToString() + " in " + fmserver.CurrentLayout);
Console.WriteLine("script error = " + fmserver.lastErrorCodeScriptPreRequest);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// create a new record and set some data
Console.WriteLine("==> Creating a new record with data...");
newRecordId = 0;
fmserver.SetLayout(testLayoutData);
// create a new request and specify what data to set in what field
var request = fmserver.NewRecordRequest();
request.AddField("country", GetRandomString());
// and run a script
request.AddScript(ScriptTypes.after, "log", "after creating record");
// execute the request
response = await request.Execute();
if (fmserver.lastErrorCode == 0)
{
newRecordId = response;
Console.WriteLine("new record = " + newRecordId.ToString() + " in " + fmserver.CurrentLayout);
Console.WriteLine("script reports error # " + fmserver.lastErrorCodeScript);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// delete a record, we will use the newRecordId that we just created
Console.WriteLine("==> deleting that last record...");
fmserver.SetLayout(testLayoutData);
response = await fmserver.DeleteRecord(newRecordId);
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine(newRecordId.ToString() + " deleted from " + fmserver.CurrentLayout);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// create a record + a related record
Console.WriteLine("==> Creating a new record with related data...");
newRecordId = 0;
fmserver.SetLayout(testLayoutDataPortal);
// create the request
request = fmserver.NewRecordRequest();
// add data to two fields, these fields belong to the table as set by the layout's context
// not related fields
request.AddField("cake", "Yummy Cake");
request.AddField("country", GetRandomString());
// using a relationship that does not allow the creation or records will generate
// error 101 "Record is missing"
//request.AddRelatedField("fruit", "cake_FRUIT", GetRandomString(), 0);
// the portal itself does not need to be on the layout
//fmserver.SetLayout("CAKE_utility__No_Portals");
// add the related field - use 0 for the related record id to indicate that it is a new record
// FMS accepts an empty recordId to denote a new related record
// here were are creating one new record and setting two related fields
request.AddRelatedField("fruit", "cake_FRUIT__ac", GetRandomString(), 0);
request.AddRelatedField("number_field", "cake_FRUIT__ac", "7", 0);
response = await request.Execute();
if (fmserver.lastErrorCode == 0)
{
newRecordId = response;
Console.WriteLine("new record = " + newRecordId.ToString() + " in " + fmserver.CurrentLayout);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// add one more related record to this parent
// ==> would be nice if this was a simpler call than having to remember to use 'add related' and 0
Console.WriteLine("==> Adding a related record to that new record...");
// create the edit request
var editRequest = fmserver.EditRequest(newRecordId);
// add the new related record
editRequest.AddRelatedField("fruit", "cake_FRUIT__ac", GetRandomString(), 0);
response = await editRequest.Execute();
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("related record added to " + newRecordId.ToString() + " in " + fmserver.CurrentLayout);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// do some edits on the empty record we created earlier
Console.WriteLine("==> Adding data to the empty record...");
fmserver.SetLayout(testLayoutData);
// create the edit request
editRequest = fmserver.EditRequest(emptyRecordId);
// modify a field, in this case a repeating field
editRequest.AddField("field_number_repeat", "100", 1);
// execute the request
response = await editRequest.Execute();
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("data added to record = " + emptyRecordId.ToString() + " in " + fmserver.CurrentLayout);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// get a record and then the container
Console.WriteLine("==> Get all the record data for recordId " + newRecordId.ToString() + " and then the container data");
int targetRecordId = 10000;
string containerField = "container_field";
// what layout has a container field on it?
fmserver.SetLayout(testLayoutData);
// create a find request, using the record that we create a while ago
var findMyRecord = fmserver.FindRequest(targetRecordId);
// execute the find
var myData = await findMyRecord.Execute();
// work with the result returned to get the URL of the container data
FMData FMresult = myData.data;
FMRecordSet FMrecords = FMresult.foundSet;
// there is only one record
FMRecord row = FMrecords.records.First();
// get the URL from the container field
string url = row.fieldsAndData[containerField];
fmserver.SetDownloadFolder(@"C:\Users\Public");
// get the container data
FileInfo containerData = await fmserver.DownloadFileFromContainerField(url);
if (containerField != null)
{
Console.WriteLine("File downloaded as: " + containerData.FullName);
}
else
{
Console.WriteLine("could not download the container data file");
}
// ---------------------------------------------------------------------------------------------------
// get a record and its portal data
Console.WriteLine("==> Get all the record data for recordId " + newRecordId.ToString());
fmserver.SetLayout(testLayoutDataPortal);
// create a find request, using the record that we create a while ago
var findRequest = fmserver.FindRequest(newRecordId);
// execute the record
var getResponse = await findRequest.Execute();
// save this reponse, we'll re-use it
var savedResponseWithPortals = getResponse;
if (getResponse.errorCode == 0)
{
Console.WriteLine("record count for " + newRecordId.ToString() + " in " + fmserver.CurrentLayout + " is " + getResponse.recordCount + ", with " + getResponse.data.relatedTableNames.Count + " portals");
newRecordModId = Convert.ToInt32(getResponse.data.foundSet.records[0].modId);
}
else
{
Console.WriteLine(getResponse.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// get a record but use a different response layout
Console.WriteLine("==> Get all the record data for recordId " + newRecordId.ToString() + " - but different response layout");
fmserver.SetLayout(testLayoutDataPortal);
// create a find request, using the record that we create a while ago
findRequest = fmserver.FindRequest(newRecordId, testLayoutResponse);
// execute the record
getResponse = await findRequest.Execute();
if (getResponse.errorCode == 0)
{
Console.WriteLine("record count for " + newRecordId.ToString() + " in " + fmserver.CurrentLayout + " is " + getResponse.recordCount + ", with " + getResponse.data.relatedTableNames.Count + " portals");
newRecordModId = Convert.ToInt32(getResponse.data.foundSet.records[0].modId);
}
else
{
Console.WriteLine(getResponse.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// get a record but use a different response layout and run scripts
Console.WriteLine("==> Get all the record data for recordId " + newRecordId.ToString() + " - but different response layout, and run scripts");
fmserver.SetLayout(testLayoutDataPortal);
// create a find request, using the record that we create a while ago
findRequest = fmserver.FindRequest(newRecordId, testLayoutResponse);
findRequest.AddScript(ScriptTypes.before, "log", "before - Etiam porta sem malesuada magna mollis euismod.");
findRequest.AddScript(ScriptTypes.beforeSort, "log", "before sort - Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.");
findRequest.AddScript(ScriptTypes.after, "log", "after - Donec sed odio dui. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.");
// execute the record
getResponse = await findRequest.Execute();
if (getResponse.errorCode == 0)
{
Console.WriteLine("record count for " + newRecordId.ToString() + " in " + fmserver.CurrentLayout + " is " + getResponse.recordCount + ", with " + getResponse.data.relatedTableNames.Count + " portals");
newRecordModId = Convert.ToInt32(getResponse.data.foundSet.records[0].modId);
}
else
{
Console.WriteLine(getResponse.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// update a specific related record
// restore the response we had before
getResponse = savedResponseWithPortals;
// the the Table Occurrence name of the first related set of the first found record, from one of our previous requests
string TOname = getResponse.data.foundSet.records[0].relatedRecordSets[0].tableName;
FMRecord firstRelatedRecord = getResponse.data.foundSet.records[0].relatedRecordSets[0].records[0];
// field name from that related table, and its original value, last field in the list
KeyValuePair <string, string> kv = firstRelatedRecord.fieldsAndData.ElementAt(1); // second field to avoid recordId and modId
string oldValue = kv.Value;
string relatedFieldName = kv.Key;
// record id for the first related record
int relatedRecordId = Convert.ToInt32(getResponse.data.foundSet.records[0].relatedRecordSets[0].records[0].recordId);
// create the edit request
editRequest = fmserver.EditRequest(newRecordId);
// modify a field, in this case a repeating field
string newValue = "99";
editRequest.AddRelatedField(relatedFieldName, TOname, newValue, relatedRecordId);
// execute the request
response = await editRequest.Execute();
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("data updated on related record = " + relatedRecordId.ToString() + " in " + fmserver.CurrentLayout + ", field = " + relatedFieldName + ", old value = " + oldValue + ", new value = " + newValue);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// get data that same record but with just one portal instead of everything
Console.WriteLine("==> Get record data plus a selected portal...");
// get the first portal name from the previous test
string portalName = getResponse.data.foundSet.records[0].relatedRecordSets[0].tableLayoutObjectName;
if (portalName == null)
{
// portal not named on the layout, use the relationship name
portalName = getResponse.data.foundSet.records[0].relatedRecordSets[0].tableName;
}
// create the find request
findRequest = fmserver.FindRequest(newRecordId);
// specify the portal name to include
findRequest.AddPortal(portalName);
// execute the request
var getResponsePartial = await findRequest.Execute();
if (getResponsePartial.errorCode == 0)
{
Console.WriteLine("record count for " + newRecordId.ToString() + " in " + fmserver.CurrentLayout + " is " + getResponsePartial.recordCount + ", with " + getResponsePartial.data.relatedTableNames.Count + " portals");
}
else
{
Console.WriteLine(getResponsePartial.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// try with a portal that does not have a layout object name, does it then use the relationship/TO name?
// seems not to, always fails. Not sure if that is a bug - waiting on feedback from FMI.
Console.WriteLine("==> Get record data plus a selected portal that has no object name...");
Console.WriteLine("==> EXPECTED TO FAIL WITH AN ERROR, FM requires a named portal.");
// get the first portal name from the previous test
portalName = getResponse.data.foundSet.records[0].relatedRecordSets.Last().tableName;
findRequest = fmserver.FindRequest(newRecordId);
findRequest.AddPortal(portalName);
getResponsePartial = await findRequest.Execute();
if (getResponsePartial.errorCode == 0)
{
Console.WriteLine("record count for " + newRecordId.ToString() + " in " + fmserver.CurrentLayout + " is " + getResponsePartial.recordCount + ", with " + getResponsePartial.data.relatedTableNames.Count + " portals");
}
else
{
Console.WriteLine(getResponsePartial.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// delete related record
Console.WriteLine("==> delete a related record");
// ==> can only do one at a time otherwise json complains of duplicate 'relatedRecord" key
// ==> needs to be fixed to not allow multiple
// set the context
fmserver.SetLayout(testLayoutDataPortal);
// grab the first record
FMRecord firstRecord = getResponse.data.foundSet.records[0];
// and the first related record for that record, from the first portal
firstRelatedRecord = firstRecord.relatedRecordSets[0].records[0];
// get that record's id
int firstReleatedRecordId = Convert.ToInt32(firstRelatedRecord.recordId);
// and the table occurrence for that first related set of records
string relationship = firstRecord.relatedRecordSets[0].tableName;
// execute the delete command
response = await fmserver.DeleteRelatedRecord(newRecordId, relationship, firstReleatedRecordId);
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("related record " + firstReleatedRecordId.ToString() + " deleted in " + fmserver.CurrentLayout + " from " + relationship + " for parent record " + newRecordId);
}
else
{
Console.WriteLine(getResponse.errorCode.ToString());
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// create a record and set repeating field
Console.WriteLine("==> new record and set repeating field...");
// some housekeeping since we keep reusing this variable
newRecordId = 0;
// set the context
fmserver.SetLayout(testLayoutData);
// create the request
request = fmserver.CreateRequest();
// add a field + value to the request
request.AddField("country", GetRandomString());
// add another field, this one is a repeating field
// set 2nd repetition
request.AddField("field_number_repeat", "17", 2);
// execute the request
response = await request.Execute();
if (fmserver.lastErrorCode == 0)
{
newRecordId = response;
Console.WriteLine("new record created and repeating field set = " + newRecordId + " in " + fmserver.CurrentLayout);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// edit a record and specify a particular mod id
// hat is the mod id of a newly created record, 0 or 1? --> 0
// ==> can fail because we didn't correctly capture the newRecordModId from the record we just created
// we would have to do a Get on it first to know it.
Console.WriteLine("==> edit a record by specifying both recordId and modId");
// set the context
fmserver.SetLayout(testLayoutData);
// create the request, specifying the target record by id and also specifying the mod id
var requestEditWithMod = fmserver.EditRequest(newRecordId, newRecordModId);
// set the value for the target field
requestEditWithMod.AddField("fruit", "Lorem Ipsum");
// execute the request
response = await requestEditWithMod.Execute();
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("record edited = " + newRecordId + " in " + fmserver.CurrentLayout + " - mod id was " + newRecordModId);
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// edit a record with non-matching mod id
// -> same as above but change the mod id to lower than what is expected
// ---------------------------------------------------------------------------------------------------
// do a search
Console.WriteLine("==> doing a find with criteria for range and start record");
// set the context
fmserver.SetLayout(testLayoutDataPortal);
// create the request
var getSelectedRecords = fmserver.FindRequest();
// specify how many records to return
getSelectedRecords.SetHowManyRecords(3);
// specify the start record (offset)
getSelectedRecords.SetStartRecord(2);
// execute the request
var getFindResponse = await getSelectedRecords.Execute();
if (getFindResponse.errorCode > 0)
{
Console.WriteLine(getFindResponse.errorCode.ToString() + " - " + getFindResponse.result);
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
else
{
// at this point you could serialize these classes in anything you like
// whatever is supported by the version of .NET for your platform
// XML, JSON, DataSet, DataTable,...
// get some output to the console
PrintOut(getFindResponse);
}
// ---------------------------------------------------------------------------------------------------
// same search and include only two records from the first portal
Console.WriteLine("==> doing a find with criteria for range and start record, and a sort, and a selected portal with limited records");
// set context
fmserver.SetLayout(testLayoutDataPortal2);
// create the request
getSelectedRecords = fmserver.FindRequest();
// add a portal, remember that you can use named parameters for any combination of startAt and howMany
// those are optional parameters
getSelectedRecords.AddPortal("first_portal", howManyRecords: 1, StartAtRecordNumber: 5);
// specify the regular found set criteria (range and offset)
getSelectedRecords.SetHowManyRecords(5);
getSelectedRecords.SetStartRecord(10);
// and also sort that found set
getSelectedRecords.AddSortField("modification_count", FMS.SortDirection.descend);
getSelectedRecords.AddSortField("country", FMS.SortDirection.ascend);
// execute the request
getFindResponse = await getSelectedRecords.Execute();
if (getFindResponse.errorCode > 0)
{
Console.WriteLine(getFindResponse.errorCode.ToString() + " - " + getFindResponse.result);
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
else
{
// at this point you could serialize these classes in anything you like
// whatever is supported by the version of .NET for your platform
// XML, JSON, DataSet, DataTable,...
// get some output to the console
PrintOut(getFindResponse);
}
// ---------------------------------------------------------------------------------------------------
// do an actual search, for values in a field
Console.WriteLine("==> doing a find with criteria for multiple fields");
// set the context
// fmserver.SetLayout(testLayoutDataPortal);
// create the request
getSelectedRecords = fmserver.FindRequest();
// add two sets of search criteria (group of fields), these will be executed as an AND search
var request1 = getSelectedRecords.SearchCriterium();
request1.AddFieldSearch("country", "belgium");
request1.AddFieldSearch("cake", "spice");
var request2 = getSelectedRecords.SearchCriterium();
request2.AddFieldSearch("country", "belgium");
request2.AddFieldSearch("cake", "rum");
// only return related data from the first portal
getSelectedRecords.AddPortal("first_portal");
// execute the request
getFindResponse = await getSelectedRecords.Execute();
if (getFindResponse.errorCode > 0)
{
Console.WriteLine(getFindResponse.errorCode.ToString() + " - " + getFindResponse.result);
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
else
{
// at this point you could serialize these classes in anything you like
// whatever is supported by the version of .NET for your platform
// XML, JSON, DataSet, DataTable,...
// get some output to the console
PrintOut(getFindResponse);
}
// ---------------------------------------------------------------------------------------------------
// set a global field
Console.WriteLine("==> setting a single global field");
// set the context
fmserver.SetLayout(testLayoutData);
// set the global (executes it automatically)
var globalResponse = await fmserver.SetSingleGlobalField("global_field_text", "FRUIT", "Hello World!");
// get a random record back to confirm the values
findRequest = fmserver.FindRequest(1);
getFindResponse = await findRequest.Execute();
if (getFindResponse.errorCode > 0)
{
Console.WriteLine(getFindResponse.errorCode.ToString() + " - " + getFindResponse.result);
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
else
{
// at this point you could serialize these classes in anything you like
// whatever is supported by the version of .NET for your platform
// XML, JSON, DataSet, DataTable,...
// get some output to the console
PrintOut(getFindResponse);
}
// ---------------------------------------------------------------------------------------------------
// add multiple globals and get the response back
Console.WriteLine("==> setting multiple global fields, including repeats");
// set the context
fmserver.SetLayout(testLayoutData);
// create a list of global fields and their values you want to set
List <Field> fields = new List <Field>();
fields.Add(new Field("global_field_number", "FRUIT", 1, "7", 17));
fields.Add(new Field("global_field_text", "FRUIT", 1, "Lorem Ipsum", 17));
// and setting the 3rd repeat of a global:
fields.Add(new Field("global_field_number_repeat", "FRUIT", 3, "77", 17));
// execute it
globalResponse = await fmserver.SetMultipleGlobalField(fields);
// get a random record back to confirm the values
findRequest = fmserver.FindRequest(1);
getFindResponse = await findRequest.Execute();
if (getFindResponse.errorCode > 0)
{
Console.WriteLine(getFindResponse.errorCode.ToString() + " - " + getFindResponse.result);
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
else
{
// at this point you could serialize these classes in anything you like
// whatever is supported by the version of .NET for your platform
// XML, JSON, DataSet, DataTable,...
// get some output to the console
PrintOut(getFindResponse);
}
// upload a file to a container
string file = @"C:\Users\Wim Decorte\Downloads\faulty_20180205.zip";
FileInfo f = new FileInfo(file);
//byte[] filedata = System.IO.File.ReadAllBytes(file); // ---> no need, doing that in the library so clean up
fmserver.SetLayout(testLayoutData);
// int x = await fmserver.UploadFileIntoContainerField(10000, "container_field", filedata, "faulty_20180205.zip");
int x = await fmserver.UploadFileIntoContainerField(10000, "container_field", f);
if (fmserver.lastErrorCode == 0)
{
Console.WriteLine("file uploaded to container");
}
else
{
Console.WriteLine(fmserver.lastErrorCode.ToString() + " - " + fmserver.lastErrorMessage);
}
// ---------------------------------------------------------------------------------------------------
// do something with getting containers too?
// stream to base64 text?
// probably not, FMS give you back a URL to use, you can grab the byte[] and work from that if you need to
// ---------------------------------------------------------------------------------------------------
// add a sort by value list name
// ---------------------------------------------------------------------------------------------------
// log out
Console.WriteLine("Logging out...");
try
{
int responseCode = await fmserver.Logout();
Console.WriteLine("logout response = " + responseCode.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Logout failed = " + ex.Message);
}
// ---------------------------------------------------------------------------------------------------
// wrapping up
DateTime end = DateTime.Now;
double elapsed = (end - start).TotalMilliseconds;
Console.WriteLine(end.ToString());
Console.WriteLine("total milliseconds = " + elapsed.ToString());
Console.WriteLine("");
Console.Beep();
Console.WriteLine("Press any key to close this window...");
Console.ReadKey();
}
