> ## Documentation Index > Fetch the complete documentation index at: https://docs-staging-quickstart-revamp.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. > Learn how to export your Auth0 user data and import it into Marketo. # Export User Data to Marketo In this article, you’ll learn how to export user data in Auth0 to a CSV file then import it into Marketo using the [Bulk Leads endpoint](http://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#/Bulk_Leads) of the Marketo REST API. ## Create a user data file Start by navigating to the [Extensions](https://manage.auth0.com/#/extensions) section of the Dashboard and open the **User Import / Export Extension**. On the extension page, select **Export** from the menu. Next, set the **Export Format** to the required file format. Marketo accepts file imports in CSV format so choose the `Tab Separated Value file (*.csv)` option. At the top in the **Fields** section, provide a **User Field** and **Column Name** for each user attribute to include in the export. For example:
User Field Column Name
email Email Address
created\_at Created At
given\_name First Name
family\_name Last Name
After adding the user fields, click on the **Export Users** button to start the export. Once the export is complete, download the CSV file to use in the following section. ### Import a user data file Before you get started, you can find more information by visiting [Marketo Documentation: Bulk Lead Import](http://developers.marketo.com/rest-api/bulk-import/bulk-lead-import/). To import the user data file to Marketo, perform a POST request to the [Bulk Leads endpoint](http://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#/Bulk_Leads). Set the content-type header of the request to `multipart/form-data` and include a `file` parameter with your exported CSV file as well as format parameter set to `csv`. For example: ```bash cURL lines curl --request POST \ --url https://marketo_rest_api_base_url/bulk/v1/leads.json \ --header 'authorization: Bearer {MARKETO_ACCESS_TOKEN}' \ --form file=@auth0_users.csv \ --form format=csv ``` ```csharp C# lines var client = new RestClient("https://marketo_rest_api_base_url/bulk/v1/leads.json"); var request = new RestRequest(Method.POST); request.AddHeader("authorization", "Bearer {MARKETO_ACCESS_TOKEN}"); request.AddHeader("content-type", "multipart/form-data; boundary=---011000010111000001101001"); request.AddParameter("multipart/form-data; boundary=---011000010111000001101001", "-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n", ParameterType.RequestBody); IRestResponse response = client.Execute(request); ``` ```go Go lines expandable package main import ( "fmt" "strings" "net/http" "io/ioutil" ) func main() { url := "https://marketo_rest_api_base_url/bulk/v1/leads.json" payload := strings.NewReader("-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n") req, _ := http.NewRequest("POST", url, payload) req.Header.Add("authorization", "Bearer {MARKETO_ACCESS_TOKEN}") req.Header.Add("content-type", "multipart/form-data; boundary=---011000010111000001101001") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() body, _ := ioutil.ReadAll(res.Body) fmt.Println(res) fmt.Println(string(body)) } ``` ```java Java lines HttpResponse response = Unirest.post("https://marketo_rest_api_base_url/bulk/v1/leads.json") .header("authorization", "Bearer {MARKETO_ACCESS_TOKEN}") .header("content-type", "multipart/form-data; boundary=---011000010111000001101001") .body("-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n") .asString(); ``` ```javascript Node.JS lines var axios = require("axios").default; var options = { method: 'POST', url: 'https://marketo_rest_api_base_url/bulk/v1/leads.json', headers: { authorization: 'Bearer {MARKETO_ACCESS_TOKEN}', 'content-type': 'multipart/form-data; boundary=---011000010111000001101001' }, data: '-----011000010111000001101001\r\nContent-Disposition: form-data; name="file"; filename="auth0_users.csv"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name="format"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n' }; axios.request(options).then(function (response) { console.log(response.data); }).catch(function (error) { console.error(error); }); ``` ```obj-c Obj-C lines expandable #import NSDictionary *headers = @{ @"authorization": @"Bearer {MARKETO_ACCESS_TOKEN}", @"content-type": @"multipart/form-data; boundary=---011000010111000001101001" }; NSArray *parameters = @[ @{ @"name": @"file", @"fileName": @"auth0_users.csv", @"contentType": @"text/csv" }, @{ @"name": @"format", @"value": @"csv", @"contentType": @"text/plan" } ]; NSString *boundary = @"---011000010111000001101001"; NSError *error; NSMutableString *body = [NSMutableString string]; for (NSDictionary *param in parameters) { [body appendFormat:@"--%@\r\n", boundary]; if (param[@"fileName"]) { [body appendFormat:@"Content-Disposition:form-data; name=\"%@\"; filename=\"%@\"\r\n", param[@"name"], param[@"fileName"]]; [body appendFormat:@"Content-Type: %@\r\n\r\n", param[@"contentType"]]; [body appendFormat:@"%@", [NSString stringWithContentsOfFile:param[@"fileName"] encoding:NSUTF8StringEncoding error:&error]]; if (error) { NSLog(@"%@", error); } } else { [body appendFormat:@"Content-Disposition:form-data; name=\"%@\"\r\n\r\n", param[@"name"]]; [body appendFormat:@"%@", param[@"value"]]; } } [body appendFormat:@"\r\n--%@--\r\n", boundary]; NSData *postData = [body dataUsingEncoding:NSUTF8StringEncoding]; NSMutableURLRequest *request = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:@"https://marketo_rest_api_base_url/bulk/v1/leads.json"] cachePolicy:NSURLRequestUseProtocolCachePolicy timeoutInterval:10.0]; [request setHTTPMethod:@"POST"]; [request setAllHTTPHeaderFields:headers]; [request setHTTPBody:postData]; NSURLSession *session = [NSURLSession sharedSession]; NSURLSessionDataTask *dataTask = [session dataTaskWithRequest:request completionHandler:^(NSData *data, NSURLResponse *response, NSError *error) { if (error) { NSLog(@"%@", error); } else { NSHTTPURLResponse *httpResponse = (NSHTTPURLResponse *) response; NSLog(@"%@", httpResponse); } }]; [dataTask resume]; ``` ```php PHP lines expandable $curl = curl_init(); curl_setopt_array($curl, [ CURLOPT_URL => "https://marketo_rest_api_base_url/bulk/v1/leads.json", CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => "", CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 30, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => "POST", CURLOPT_POSTFIELDS => "-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n", CURLOPT_HTTPHEADER => [ "authorization: Bearer {MARKETO_ACCESS_TOKEN}", "content-type: multipart/form-data; boundary=---011000010111000001101001" ], ]); $response = curl_exec($curl); $err = curl_error($curl); curl_close($curl); if ($err) { echo "cURL Error #:" . $err; } else { echo $response; } ``` ```python Python lines import http.client conn = http.client.HTTPSConnection("marketo_rest_api_base_url") payload = "-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n" headers = { 'authorization': "Bearer {MARKETO_ACCESS_TOKEN}", 'content-type': "multipart/form-data; boundary=---011000010111000001101001" } conn.request("POST", "/bulk/v1/leads.json", payload, headers) res = conn.getresponse() data = res.read() print(data.decode("utf-8")) ``` ```ruby Ruby lines require 'uri' require 'net/http' require 'openssl' url = URI("https://marketo_rest_api_base_url/bulk/v1/leads.json") http = Net::HTTP.new(url.host, url.port) http.use_ssl = true http.verify_mode = OpenSSL::SSL::VERIFY_NONE request = Net::HTTP::Post.new(url) request["authorization"] = 'Bearer {MARKETO_ACCESS_TOKEN}' request["content-type"] = 'multipart/form-data; boundary=---011000010111000001101001' request.body = "-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"file\"; filename=\"auth0_users.csv\"\r\nContent-Type: text/csv\r\n\r\n\r\n-----011000010111000001101001\r\nContent-Disposition: form-data; name=\"format\"\r\nContent-Type: text/plan\r\n\r\ncsv\r\n-----011000010111000001101001--\r\n" response = http.request(request) puts response.read_body ``` ```swift Swift lines expandable import Foundation let headers = [ "authorization": "Bearer {MARKETO_ACCESS_TOKEN}", "content-type": "multipart/form-data; boundary=---011000010111000001101001" ] let parameters = [ [ "name": "file", "fileName": "auth0_users.csv", "contentType": "text/csv" ], [ "name": "format", "value": "csv", "contentType": "text/plan" ] ] let boundary = "---011000010111000001101001" var body = "" var error: NSError? = nil for param in parameters { let paramName = param["name"]! body += "--\(boundary)\r\n" body += "Content-Disposition:form-data; name=\"\(paramName)\"" if let filename = param["fileName"] { let contentType = param["content-type"]! let fileContent = String(contentsOfFile: filename, encoding: String.Encoding.utf8) if (error != nil) { print(error) } body += "; filename=\"\(filename)\"\r\n" body += "Content-Type: \(contentType)\r\n\r\n" body += fileContent } else if let paramValue = param["value"] { body += "\r\n\r\n\(paramValue)" } } let request = NSMutableURLRequest(url: NSURL(string: "https://marketo_rest_api_base_url/bulk/v1/leads.json")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "POST" request.allHTTPHeaderFields = headers request.httpBody = postData as Data let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ``` The response should look something like this: ```json lines { "requestId": "e42b#14272d07d78", "success": true, "result": [{ "batchId": 1234, "status": "Importing" }] } ``` You can check the status of your import using the [Get Import Lead Status API](/docs/) and your import job's `batchId`. For example: ```bash cURL lines curl --request GET \ --url https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json \ --header 'authorization: Bearer {MARKETO_ACCESS_TOKEN}' ``` ```csharp C# lines var client = new RestClient("https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json"); var request = new RestRequest(Method.GET); request.AddHeader("authorization", "Bearer {MARKETO_ACCESS_TOKEN}"); IRestResponse response = client.Execute(request); ``` ```go Go lines package main import ( "fmt" "net/http" "io/ioutil" ) func main() { url := "https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json" req, _ := http.NewRequest("GET", url, nil) req.Header.Add("authorization", "Bearer {MARKETO_ACCESS_TOKEN}") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() body, _ := ioutil.ReadAll(res.Body) fmt.Println(res) fmt.Println(string(body)) } ``` ```java Java lines HttpResponse response = Unirest.get("https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json") .header("authorization", "Bearer {MARKETO_ACCESS_TOKEN}") .asString(); ``` ```javascript Node.JS lines var axios = require("axios").default; var options = { method: 'GET', url: 'https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json', headers: {authorization: 'Bearer {MARKETO_ACCESS_TOKEN}'} }; axios.request(options).then(function (response) { console.log(response.data); }).catch(function (error) { console.error(error); }); ``` ```obj-c Obj-C lines #import NSDictionary *headers = @{ @"authorization": @"Bearer {MARKETO_ACCESS_TOKEN}" }; NSMutableURLRequest *request = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:@"https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json"] cachePolicy:NSURLRequestUseProtocolCachePolicy timeoutInterval:10.0]; [request setHTTPMethod:@"GET"]; [request setAllHTTPHeaderFields:headers]; NSURLSession *session = [NSURLSession sharedSession]; NSURLSessionDataTask *dataTask = [session dataTaskWithRequest:request completionHandler:^(NSData *data, NSURLResponse *response, NSError *error) { if (error) { NSLog(@"%@", error); } else { NSHTTPURLResponse *httpResponse = (NSHTTPURLResponse *) response; NSLog(@"%@", httpResponse); } }]; [dataTask resume]; ``` ```php PHP lines $curl = curl_init(); curl_setopt_array($curl, [ CURLOPT_URL => "https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json", CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => "", CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 30, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => "GET", CURLOPT_HTTPHEADER => [ "authorization: Bearer {MARKETO_ACCESS_TOKEN}" ], ]); $response = curl_exec($curl); $err = curl_error($curl); curl_close($curl); if ($err) { echo "cURL Error #:" . $err; } else { echo $response; } ``` ```python Python lines import http.client conn = http.client.HTTPSConnection("marketo_rest_api_base_url") headers = { 'authorization': "Bearer {MARKETO_ACCESS_TOKEN}" } conn.request("GET", "/bulk/v1/leads/batch/BATCH_ID.json", headers=headers) res = conn.getresponse() data = res.read() print(data.decode("utf-8")) ``` ```ruby Ruby lines require 'uri' require 'net/http' require 'openssl' url = URI("https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json") http = Net::HTTP.new(url.host, url.port) http.use_ssl = true http.verify_mode = OpenSSL::SSL::VERIFY_NONE request = Net::HTTP::Get.new(url) request["authorization"] = 'Bearer {MARKETO_ACCESS_TOKEN}' response = http.request(request) puts response.read_body ``` ```swift Swift lines import Foundation let headers = ["authorization": "Bearer {MARKETO_ACCESS_TOKEN}"] let request = NSMutableURLRequest(url: NSURL(string: "https://marketo_rest_api_base_url/bulk/v1/leads/batch/BATCH_ID.json")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "GET" request.allHTTPHeaderFields = headers let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ``` And the response: ```json lines { "requestId": "8136#146daebc2ed", "success": true, "result": [{ "batchId": 1234, "status": "Complete", "numOfLeadsProcessed": 123, "numOfRowsFailed": 0, "numOfRowsWithWarning": 0 }] } ``` That's it! You successfully imported your Auth0 users into Marketo.