Skip to content

Instantly share code, notes, and snippets.

@david1542
Created March 19, 2020 13:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save david1542/1c58aa085ecb0fedb7de36f72b9bf713 to your computer and use it in GitHub Desktop.
Save david1542/1c58aa085ecb0fedb7de36f72b9bf713 to your computer and use it in GitHub Desktop.
{
"ADS": {
"transformOptions": {
"transformers": [
{
"transformerType": "ParserTransformer",
"input": {
"typeName": "FileParserTransformerInput",
"order": 0,
"fileParsers": [
"AUTO"
],
"xlSheetExpression": null,
"xlsWorkbookPasswordExpression": null,
"allowUnquotedMultilineFields": false,
"customQuoteChar": null,
"customDelimiter": null,
"fileEncoding": null,
"jsonPath": null,
"jsonValuesOnly": false,
"rss": false,
"rssCustomHeaderName": "item",
"xmlXslTransformation": null,
"workbookPasswordEnabled": false,
"pickFirstSheetOnMismatch": null,
"jsonNestedObjects": false,
"pdfPages": null,
"pdfPageArea": null,
"pdfPassword": "",
"pdfForceSpreadsheetMethod": false,
"pdfForceNoSpreadsheetMethod": false
}
}
],
"metaData": {
"originalHeader": null,
"originalXlSheets": null
}
},
"bucketName": "ADS",
"bucketKey": "ADS",
"schema2formulas": {
"campaign_external_id": {
"primaryFormula": null,
"defaultFormula": {
"formula": "dat['campaign_name']"
}
},
"media_buy_external_id": {
"primaryFormula": null,
"defaultFormula": {
"formula": "IF(dat['media_buy_name'] != 'Default Media Buy',dat['media_buy_name'],dat['campaign_external_id'] + '-' + dat['site_external_id'] + '-' + dat['media_buy_name'])"
}
}
},
"csv2schema": null,
"schemaFieldsData": null,
"csv2similarityScores": null,
"schema2similarityScores": null,
"csvStructure": {
"fields": [
{
"name": "media_buy_custom_attribute1",
"originalDisplayName": "media_buy_custom_attribute1",
"displayName": "Platform Origin (Cheq)",
"type": "DATE",
"subType": "NONE",
"format": "yyyy-MM-dd",
"mandatory": false,
"defaultValueType": null,
"defaultFormula": {
"formula": ""
},
"availableValues": null,
"synonym": null,
"mappingType": null,
"mappingValue": null,
"aggType": null,
"allowedToChangeAggregation": false,
"maxLength": 0,
"role": "NOT_SET",
"slowlyChangingType": "NONE",
"description": null
}
],
"allFieldOptions": null,
"allFormats": {
"media_buy_end_time": [
"yyyy-MM-dd"
],
"campaign_start_time": [
"yyyy-MM-dd"
],
"date_id": [
"yyyy-MM-dd"
],
"media_buy_start_time": [
"yyyy-MM-dd"
],
"campaign_end_time": [
"yyyy-MM-dd"
]
},
"dataRows": null
},
"matchingScore": 112,
"convertEmptyNumbersToZero": false
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment