5
File Imports are the most tried and true method of getting large amounts of data into SMFC. As for limitations -- most of the issues I've seen with imports haven't been with size or row counts -- it's been with bad data, like extra CR/LFs, bad delimiters or improper text qualification. Importing structured data like XML is possible, but not recommended. ...
5
I did a file export from a dataextension like this:
DataExtract Activity1:
Pattern: TEST_SAFEHOUSE_%%Day%%%%Month%%%%Year%%.csv
ExtractType: Data Extension Extract
Column Delimiter: ;
Has Column Header: Yes
Uses Line Feed: Yes
Text Qualified: No
DataExtract Activity2:
Pattern:TEST_SAFEHOUSE_%%Day%%%%Month%%%%Year%%.csv
ExtractType: File Convert
ConvertTo:...
4
You can use the SOAP API to programmatically define and execute a data extract, analogous to creating the data extract activity in automation studio, but with the benefit of being able to set the parameters, including start and end date, on the fly. Here's the example SOAP envelope provided in the documentation:
<Envelope xmlns="http://schemas.xmlsoap....
4
Since you wanting to update the All Subscribers list (not a data extension), the correct field name is Email Address (note: the space). You will need to rename the header in your file to match or choose to map fields manually in your import configuration. If subscriber key is enabled in your account, you will also need to supply a column named subscriber ...
3
Exactly as @EazyE commented, you are doing a POST which is a 'create' and to update you need to do a PATCH which is update. Although the Endpoint is mostly the same, the Method has to be different.
There is also a slight difference in that you need to include the dataextractid inside the URL at the end for the PATCH as well as in the JSON in the body.
Making ...
2
Probably the closest thing you can get to something like a Tracking Extract Activity would be to schedule a "SMS Message Detail Report" from within Analytics Builder and schedule it to save the file to the Enhanced FTP.
The resulting CSV report gives detail of every Mobile Originated and Mobile Terminated message that's gone through MobileConnect in the ...
2
I am assuming you are taking a tracking extract, so please see below for necessary tasks to export onto an FTP location and unzip:
Create and execute your data extract / tracking extract
Create a File Transfer to move onto FTP (Move a File From Safehouse)
Create a File Transfer to unzip your file (Manage File)
Details on these steps:
For the tracking ...
2
welcome to SFSE!
I am afraid you are overthinking it. To set it to a subfolder, you need to create a file location specific to it.
Here are the steps:
Go to File Locations in Admin tab
Click on Create
add in name/externalkey/description
Select 'External FTP Site' (or SFTP, etc) from 'Location Type'
In Url you put the FULL Url, including subdirectories. E....
2
The answer is all there in the name of those two fields.
Unique Clicks are uniqueness across everything. So if I click three different links in the email, I'm counted once under this.
Unique Clicks for URL are uniqueness across that one URL, even if it appears multiple times in the email. So if I click three links, two of which are the same URL, I'm ...
2
The file is likely in use by another process. You can:
Retry the activity or the automation that it's a part of if this error does not typically occur.
If this error continues, ensure that the file is not being used by another process.
It is also very likely that the previously transferred file was interrupted in the middle of being processed and put in a ...
2
Query the _Subscribers data view. Subscribers is not restricted to 6 months as other data views are.
SELECT SubscriberKey
FROM _Subscribers
WHERE Status = 'Unsubscribed'
2
This is explained further in documentation, under Extract Output Reference.
Extract types must be provisioned for your account. Contact your
Marketing Cloud representative for more information.
Just log a new support case requesting these to be enabled on your MC instance.
2
I've never managed to do this with the SOAP API. However, you can hack the internal route pretty easily. Get the Data Extension Extract ID by inspecting the traffic in your browser while opening the Data Extract Activity in Automation Studio.
PATCH: {{tsRestEndpoint}}automation/v1/dataextracts/{{DataExtractId}}
{
"name": "Test Extract",
"key": "Test ...
1
It is not possible to connect a Google Cloud Storage bucket to MC, as the only methods available for GCS are (as per documentation):
Write and read files from Cloud Storage buckets by using the gsutil
command-line tool or the Cloud Storage API.
As MC only supports FTP/SFTP as a File Location, you will need to put an FTP server between MC and your GCS. ...
1
You have to use a Data Extract and File Transfer activities to export a Data Extension:
Data Extract configuration: The External Key field can be empty as it refers to the Data Extract activity itself. It is in the second step 'Configuration' where you have to put the external key of the Data Extension you want to export (in the DECustomer Key field).
File ...
1
If you had your file in MC SFTP already, you can use "File Transfer" activity (you have to configure it property though) followed by an import one for instance (this could be automated by leveraging Automation Studio).
Data Extract is not required in the scenario you have described.
1
I'm not aware of a way to model your output in this fashion. Extract output formatting is pretty limited.
For some reason you even need to raise a support ticket to enable UTF8 encoding.
However, there are quite some "hidden features" not documented anywhere that can be activated through support.
As DMP integrations don't come very often this might ...
1
In All Subscribers, you can search by Subscriber Status. I searched all 'Unsubscribed' and was able to extract just unsubscribers with their unsubscribed date and reason.
1
To get the statuses from a child business unit, run a tracking extract and include 'Extract Subscribers' and 'Include All Subscribers'. Typically I'll add this to an automation that then imports the extract file into a data extension that you can then query/filter from easily.
Your extract should include the following fields:
1
Here are some screenshots of an UTF8 DataExtract Activity:
1
There are only two ways to go about it -
Using Data Extract and the Import (as you described)
Writing an SSJS activity. You can read from a DE and write to a List
SQL doesn't allow writing to a list
1
Typically if Query Activities fail, it's one of these 4 things:
Primary key violation -- your query results in duplicate rows not allowed by the primary key
Inserting a null value into a non-nullable field
Inserting a value too long for the field (truncation)
Timeout -- if your query doesn't complete within the 30 minute timeout window, it'll error out.
...
1
I discovered there is a custom extract that support can enable. It is named 'Custom DE Extract With Zip2'. The extract type will perform a data extract on a data extension and zip the file that it places in the Safehouse. You can then perform a file transfer on this file to move it to the enhanced FTP or an external FTP.
The downside is that each ...
1
In case it's useful for anyone else having this issue - to extract as a CSV, tick the 'Has Header Column' and leave others as false.
1
After looking at this through the workbench, this is indeed an sObject, and it's called OpportunityCompetitor.
If you're using the Salesforce-provided Apex Data Loader, you'll need to check "Show All Salesforce Objects" to have OpportunityCompetitor appear in the list of objects.
If you want to simply find all competitors related to a given Opportunity, ...
1
I know this is a late answer, but in case you haven't already solved this.
Retrieveing data from a Data Extension
The below sample includes a 'filter' to a specific email address, which is not necessary, but I would highly recommend a filter, especially on larger DEs to ensure your call does not time out or butt up on the 2500 record limit of API calls. (...
1
Be sure you have not checked the 'File is compressed' checkbox in the File Transfer Activity.
It could be that the file you are opening is a .zip file.
1
Found the answer after I posted, thought others may want to know.
I created a query that looked at the _ListSubscribers data view. Example below:
Select [EmailAddress]
FROM
_ListSubscribers
WHERE
ListID = XXXXXXXX
Then, I created an automation that runs this query, performs a data extract of the target DE, then a file transfer activity to move the target ...
1
You can export files in base-64 format, but you can only import files using files, as documented in Uploading Attachments. Basically, the Body needs to be specified as a file path. The three required fields are Name, ParentId, and Body. For Documents, you need a FolderId, Name, and Body.
1
No, I can't use Base64 to insert Documents.
Received Exceeded Max Field size
Also there is mention in the documentation that VersionData for ContentVersion is automatically converted into Base64, probably the same is valid for Body of Document. Strange, why didn't they mentioned Document Body conversion as well.
• VersionData - complete file path on your ...
Only top voted, non community-wiki answers of a minimum length are eligible
