def marketingCloud(bases, event1): stubObj = ET_Client.ET_Client( False, False, { 'clientid': os.environ['clientid'], 'clientsecret': os.environ['clientsecret'], 'defaultwsdl': 'https://webservice.exacttarget.com/etframework.wsdl', 'authenticationurl': os.environ['authenticationurl'], 'baseapiurl': os.environ['baseapiurl'], 'soapendpoint': os.environ['soapendpoint'], 'wsdl_file_local_loc': r'/tmp/ExactTargetWSDL.xml', 'useOAuth2Authentication': 'True', 'accountId': os.environ['accountId'] }) de = ET_Client.ET_DataExtension_Row() de.CustomerKey = bases de.auth_stub = stubObj de.props = props1 if de.CustomerKey == os.environ[ 'basesLeads_Gerais'] else props2 postResponse = de.post() # Mensagens de error para debugar depois! Caso necessário: ## print("Post Status: " + str(postResponse.status)) ## print("Code: " + str(postResponse.code)) ## print("Message: " + str(postResponse.message)) ## print("Results: " + str(postResponse.results)) if postResponse.status: return True
def get_all_rows_from_data_extension(self, data_extension_customer_key, fields_list): der = ET_Client.ET_DataExtension_Row() der.auth_stub = self.auth_stub der.CustomerKey = data_extension_customer_key der.props = fields_list return der.get()
def add_row_to_data_extension(self, data_extension_name, fields_dictionary): der = ET_Client.ET_DataExtension_Row() der.auth_stub = self.auth_stub der.Name = data_extension_name der.props = fields_dictionary return der.post()
def update_row(self, message: Dict[str, str], extension_key: str) -> bool: """ :param message: the list of dict wiht the data :param extension_key: it is the customer key or 'table name' """ logger.info("Adding a row to a data extension") row = ET_Client.ET_DataExtension_Row() row.CustomerKey = extension_key row.auth_stub = self.get_client() row.props = message response = row.patch() logger.info( f"patch_tatus: {str(response.status)}, code: {str(response.code)}, message: {str(response.message)}" ) logger.info("Results: " + str(response.results)) if int(response.status) == 200: return True return False
'Property': 'CustomerKey', 'SimpleOperator': 'equals', 'Value': NameOfDE } getResponse = myDEColumn.get() print(('Retrieve Status: ' + str(getResponse.status))) print(('Code: ' + str(getResponse.code))) print(('Message: ' + str(getResponse.message))) print(('MoreResults: ' + str(getResponse.more_results))) print(('RequestID: ' + str(getResponse.request_id))) print(('Results Length: ' + str(len(getResponse.results)))) print(('Results: ' + str(getResponse.results))) # Add a row to a data extension (using CustomerKey) print('>>> Add a row to a data extension') de4 = ET_Client.ET_DataExtension_Row() de4.CustomerKey = NameOfDE de4.auth_stub = stubObj de4.props = {"Name": "MAC3", "OtherField": "Text3"} postResponse = de4.post() print(('Post Status: ' + str(postResponse.status))) print(('Code: ' + str(postResponse.code))) print(('Message: ' + str(postResponse.message))) print(('Results: ' + str(postResponse.results))) # Add a row to a data extension (Using Name) print('>>> Add a row to a data extension') de4 = ET_Client.ET_DataExtension_Row() de4.auth_stub = stubObj de4.Name = NameOfDE de4.props = {"Name": "MAC4", "OtherField": "Text3"}