private static string DumpUniverse(IDataSetRecord record)
{
return($"Instrument: [{record.Universe.Instrument}] => {record.Data.Count} rows, {record.Fields.Count} fields\n" +
$"\tCommon Name: {record.Universe.CommonName}\n" +
$"\tPerm ID: {record.Universe.PermID}\n" +
$"\tCurrency: {record.Universe.Currency}\n");
}
public void getAirtableDataBU()
{
string dataBU = this.GET(this.AirtableURL + "/BussinessUnits", String.Format("Authorization: Bearer {0}", this.AirtableAPIKey), "");
//string dataVendors = this.GET(this.AirtableURL + "/Vendors", String.Format("Authorization: Bearer {0}", this.AirtableAPIKey), "");
//logger.Debug(dataBU);
AirtableBU BU = JsonConvert.DeserializeObject <AirtableBU>(dataBU);
//AirtableVendor Vendor = JsonConvert.DeserializeObject<AirtableVendor>(dataVendors);
foreach (Record rec in BU.records)
{
IDataSetRecord tempRecordBU = dataset.CreateRecord();
tempRecordBU.AddValue("Id", rec.fields.Id);
tempRecordBU.AddValue("Name", rec.fields.Name);
tempRecordBU.AddValue("VATID", rec.fields.VATID);
tempRecordBU.AddValue("CountryCode", rec.fields.CountryCode[0]);
tempRecordBU.AddValue("ZIP", rec.fields.ZIP);
tempRecordBU.AddValue("Street", rec.fields.Street);
tempRecordBU.AddValue("City", rec.fields.City);
this.dataset.AddRecord(tempRecordBU);
tempRecordBU = null;
}
}
public void getAirtableDataVendor()
{
string dataVendors = this.GET(this.AirtableURL + "/Vendors", String.Format("Authorization: Bearer {0}", this.AirtableAPIKey), "");
//logger.Debug(dataVendors);
Console.WriteLine(dataVendors);
//AirtableBU BU = JsonConvert.DeserializeObject<AirtableBU>(dataBU);
AirtableVendor Vendor = JsonConvert.DeserializeObject <AirtableVendor>(dataVendors);
Console.WriteLine(Vendor.ToString());
//logger.Info("Offsett" + Vendor.offset);
foreach (RecordVendor rec in Vendor.records)
{
IDataSetRecord tempRecordBU = dataset.CreateRecord();
tempRecordBU.AddValue("Id", rec.fields.Id);
if (rec.fields.BusinessUnitID != null)
{
tempRecordBU.AddValue("BusinessUnitId", rec.fields.BusinessUnitID[0]);
}
tempRecordBU.AddValue("Name", rec.fields.Name);
tempRecordBU.AddValue("VATID", rec.fields.VATID);
tempRecordBU.AddValue("NationalVATID", rec.fields.NationalVATID);
if (rec.fields.CountryCode != null)
{
tempRecordBU.AddValue("CountryCode", rec.fields.CountryCode[0]);
}
tempRecordBU.AddValue("ZIP", rec.fields.ZIP);
tempRecordBU.AddValue("IBAN", rec.fields.IBAN);
tempRecordBU.AddValue("Street", rec.fields.Street);
tempRecordBU.AddValue("City", rec.fields.City);
tempRecordBU.AddValue("BankAccount", rec.fields.BankAccount);
tempRecordBU.AddValue("BankCode", rec.fields.BankCode);
tempRecordBU.AddValue("GLCode", rec.fields.GLCode);
this.dataset.AddRecord(tempRecordBU);
tempRecordBU = null;
}
while (Vendor.offset != null && Vendor.offset != "")
{
string dataVendorsOffset = this.GET(this.AirtableURL + "/Vendors", String.Format("Authorization: Bearer {0}", this.AirtableAPIKey), "");
AirtableVendor VendorOffset = JsonConvert.DeserializeObject <AirtableVendor>(dataVendorsOffset);
foreach (RecordVendor rec in VendorOffset.records)
{
IDataSetRecord tempRecordBU = dataset.CreateRecord();
tempRecordBU.AddValue("Id", rec.fields.Id);
tempRecordBU.AddValue("BusinessUnitID", rec.fields.BusinessUnitID);
tempRecordBU.AddValue("Name", rec.fields.Name);
tempRecordBU.AddValue("VATID", rec.fields.VATID);
tempRecordBU.AddValue("NationalVATID", rec.fields.VATID);
tempRecordBU.AddValue("CountryCode", rec.fields.CountryCode[0]);
tempRecordBU.AddValue("ZIP", rec.fields.ZIP);
tempRecordBU.AddValue("Street", rec.fields.Street);
tempRecordBU.AddValue("City", rec.fields.City);
tempRecordBU.AddValue("BankAccount", rec.fields.BankAccount);
tempRecordBU.AddValue("BankCode", rec.fields.BankCode);
tempRecordBU.AddValue("GLCode", rec.fields.GLCode);
this.dataset.AddRecord(tempRecordBU);
tempRecordBU = null;
}
}
}
