Salesforce Bulk Api Example

name¶ Alias for field number 2. IBM App Connect Professional provides several techniques for you to move bulk data (thousands of records) from SAP to Salesforce. A Bulk transfer job in v2 reduces the number of steps required by the user. In this example, I am going to show how to pull leads from Salesforce and insert into SQL server table. from simple_salesforce import Salesforce sf = Salesforce (username = '[email protected] 0 simplifies uploading large amounts of data by breaking the data into batches automatically. Perform granular seeding by configuring rules that specify the object that you want to seed and the object records to use for the seeding. Salesforce Lightning Connect : Apex Adapter using REST API with Authentication. Use a Salesforce Lookup transformation to look up data in a Salesforce object. For example an initial load of an object with 1M records would use:. 2) function getBulkConnection creates connection with salesforce, you need to provide your user name and password (password + token). STEPS: Generate WSDL. salesforce training in chennai | salesforce training institute in chennai. If you are using an unlicensed and unlimited version of the package that you obtained during the beta period, Salesforce will count API calls made by the package towards your limits. OData, short for Open Data Protocol, is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. The related list provides View Request and View Response links for each batch. Salesforce UI allows you to build native mobile apps and custom web apps. Q&A for Work. The following code splits a CSV file into smaller batch files and uploads them to Salesforce. It adds some missing features of salesforce_bulk. 4) createBatchesFromCSVFile function creates result csv file and saves to path given in "csvFileName" parameter. In Next blog I will try to cover step by step procedure to use bulk API in PI. Read more Thousands of customers build and extend their Zendesk products every day by building integrations using our REST APIs and Apps Framework. but Advantco is a better one in seamless integration. Leveraging the Bulk API via OIC - First, an extract from the Oracle SFDC adapter docs - The Salesforce Bulk API enables you to handle huge data sets asynchronously with different bulk operations. Bulk Lead Import Endpoint Reference For large amounts of lead records, leads can be imported asynchronously with the bulk API. A Salesforce DX Plugin with different functionalities aimed at improving development and operational workflows - Accenture/sfpowerkit when retrieving in bulk -u. For example, let's say you've got an Account record in Salesforce with a Site field value of "Buffalo, New York 14202. 0 simplifies uploading large amounts of data by breaking the data into batches automatically.     It is a common requirement to paginate over a set of data in Visualforce page. com platform tightly integrates with the Microsoft. Salesforce Administrator Resume Examples & Samples. This example uses Workbench as the client tool for bulk move. If you view the API calls in your Salesforce instance by Client Id it will be prefixed with RestForce/, for example RestForce/My App. I need to export hundreds of thousands of lines of data from Salesforce - Opportunity Products (OpportunityLineItems) - via dataloader. It is rewritten from salesforce_bulk. In the SSIS Toolbox, locate the Salesforce Source component and drag it onto the Data Flow canvas. SOQL query in javascript example. Although this article uses the Salesforce Excel Add-In as an example, the same process can be applied to execute any stored procedure with a CData Excel Add-In. This is a command line tool that is built specifically for bulk loading and unloading of data from an MS SQL database. Node-salesforce, which is designed to be a wrapper of Salesforce REST API in Node. Bulk API has some restrictions, for example: related objects exports are not supported by this API. MuleSoft: Salesforce. 2) Click Reset Security Token. If your Auth0 domain name is not shown above and you are not using our custom domains feature, your domain name is your tenant name, plus. The following is for an enterprise account. If you need to develop tools on metadata information from Salesforce this is the API to use. API imports in open standards such as XML and OData; API also support bulk export and upload; Pre-integrated ETL tools such as MuleSoft etc. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Each recipient on the list receives their own document to sign. com data into our system, Accounts for example. I've done enough R&D to conclude that SF Bulk API is the way to go. Build more meaningful and lasting relationships and connect with your customers across sales, customer service, marketing, communities, apps, analytics, and more using our Customer Success Platform. Load data from SalesForce to MS SQL Server. Each Salesforce object has a related folder in SpringCM based on Salesforce metadata, and the configured folder path and folder name. csv file with populated data included in each request. Here are the features of the Salesforce Bulk API 2. STEPS: Generate WSDL. com Java command line application that uses the Bulk API to load data from a CSV file or JDBC database. If one checks the task status of the task on Informatica cloud, it displays it as Success. For an average 24-hour period, under normal activity, based on the above, Riva generates between 10,000 and 11,000 API calls. The Salesforce connector provides the Create and Create Bulk operations for working with the Bulk API. FirstName, Contact. 1) One Trigger Per Object A single Apex Trigger is all you need for one particular object. The timeout duration of the socket level connection to Salesforce is specified by seconds. Metadata API - Manage customizations and build tools that can manage the metadata model, not the data itself. Need a Bulk API Example to start. com data into our system, Accounts for example. there is a need to have an automated export from Salesforce where the data needs to be inserted/updated in one or many endpoints on a regular basis. Once you are at the SalesForce login screen, login with the credentials you provided when you created the SalesForce account. On the other hand, Bulk API processes data in larger batches than Batch API, resulting in a lower API calls usage per operation on large volumes of data. Choose the API that's best suited to their needs C. COM WEB SERVICES API or BULK API to transfer data We this this is a great job for the Bulk API. The cmdlets are not only a PowerShell interface to the Salesforce API, but also an SQL interface; this tutorial shows how to use both to create, retrieve, update, and delete Salesforce data. I managed to figure it out, and I would have submitted a pull request with JSON examples, but the docs are not open source, so now you get to create the JSON examples. DocuSign Rooms bring people together in a secure digital space to complete complex agreements faster, involving multiple people, documents, and stages. Select page layout and click SAVE. pip install salesforce-bulk. If the SAML configuration works, your browser will be redirected back to an Auth0 page that says "It works!!!". The following is for an enterprise account. Though the bulk of its revenue comes from its customer-relationship management (CRM) service, Salesforce also sells a complementary suite of enterprise applications focused on customer service, marketing automation, analytics and. To access the Bulk API you need to authenticate a user into Salesforce. No parameters are required in this API. You can use pre-trained classifiers or train your own classifier to solve unique use cases. 0 support with the Salesforce Connector! Also, be sure to explore Anypoint Exchange to see other resources you can use today. Developer Center. Together they make up the Salesforce data APIs. com/profile/11701794963882085815 [email protected] These include SpringCM user sync for Salesforce, bulk CSV upload, the SpringCM user interface, or the API. For example:. This component is a function that realizes the smallest unit Bulk API operation. js, enables Salesforce application development in event-driven style. The Salesforce Bulk 2. Create a new Job. Salesforce is a customer relationship management services company. In the Update processing, Salesforce ID must be speficied as a key when updating data. • The batch job data and results can also be reviewed in Salesforce (Setup -> Monitor -> Jobs -> Bulk Data Load Jobs) Conclusions. Add Batches to the Job. Secondly, I also know that standard API is used to handle the lesser amount of data, but if te data size is quite large in number for example 10 lac records, then we prefer BULK API Right?. First REST API call to create new product. used¶ Alias for field number 0. Salesforce provides an additional API, Bulk API 2. Let me draft a simple example to help you with Salesforce Bulk APi. BatchInfo being monitored - content type used at job creation. com data into our system, Accounts for example. Bulk API 2. Contribute to BreakthroughBehavioralInc/salesforce_bulk_api development by creating an account on GitHub. Salesforce Bulk API(Postman) In our previous article, we have seen the step-by-step procedure on " How to integrate Salesforce using REST API ". I am very tempted to just push this work outside Salesforce like I do with so much else and just use Java and the partner API. Use the Lightning Knowledge API Starting with API 39. For really large operations (inserts, updates, upserts, deletes, and queries) Salesforce provides the Bulk 1. according to their business need. The current Bulk API version has enabled customer to ingest millions of records per day, but as integrations and organization design become more complex, the need for a new Bulk API is evident. Bulk Send** Effortlessly send the same document (s) to multiple contacts by uploading email addresses with a. It adds some missing features of salesforce_bulk. Salesforce API version now supports API Version 44. In this example, I am going to show how to pull leads from Salesforce and insert into SQL server…. NET application hosted outside Salesforce. You can monitor a Bulk API batch in Salesforce through the Job ID for the Bulk Data Load Jobs. The business wants the Account records updated on a more frequent basis. SObject Type: Salesforce object to write to. net application so that we can access and do operations on salesforce objects through it. – Salesforce data loader good tool to load bulk amount of data into your Sobjects. Refering this article you will definitely have an clear idea on how to integrate salesforce api into. On the other hand, Bulk API processes data in larger batches than Batch API, resulting in a lower API calls usage per operation on large volumes of data. MuleSoft's Anypoint Platform™ is a unified, single solution for iPaaS and full lifecycle API management. You can spend a lot of time on step 2, but unlikely in Bulk API 1. Read more Thousands of customers build and extend their Zendesk products every day by building integrations using our REST APIs and Apps Framework. Bulk API should be used, if you are dealing with 1000s of records and batch mode. No parameters are required in this API. I need to regularly (Weekly) import automatically Contract data from an oracle database. – By using Salesforce data loader you can load up to 5,00,000 records. More about Salesforce. Example that accepts and transforms data from Salesforce. For example, when you import many records via the API, triggers operate on the full record set. Salesforce Customer Secure Login Page. Salesforce API version. This library provides some simple functions for interacting with Salesforce. 0 and Bulk 2. com Bulk API. com” and creates a relationship with this record and the Contact records. Among the above Salesforce api, today we will trying to cover the topic Salesforce rest api integration by taking example of two Salesforce systems. Limits class and can be used in a custom processors or expressions. This is a step-by-step guide with screenshots that will tell you how to download, install, configure and create everything that you need for this. Metadata components required to. Allows tracking of the execution status. Click on New button and fill all mandatory fields and select profiles. class simple_salesforce. This example assumes a unique User record exists that has an Email value of “[email protected] Build apps for the AppExchange D. To demonstrate this, we are using a tool cURL. The process for exporting data from Eloqua using the bulk API follows 3 basic steps: Create the export definition ; Synchronize the outgoing data into a temporary staging area. See here for further details and a usage example. This article will show how to connect to salesforce and consume data within ASP. SoapUI is the world's most widely-used automated testing tool for SOAP and REST APIs. When instantiating a Salesforce object, it's also possible to include an instance of requests. DocuSign is the market share leader in digital signatures (>70%) with over 300,000 companies & 200 million users: industry standard eSignature experience your customers will love. REST API for downloading objects that the BULK API does not support Replication SOAP APIs for retrieving changes in the data In order to optimise for performance and ensure the APIs are available for all of their customers, Salesforce. Update Any - Quick Bulk Record Update on Any Field - Solution Rock - AppExchange. Use the bulk query to efficiently query large data sets and reduce the number of API requests. Tuning Operations by Configuring Batch Sizes. You want to load tons of data into Salesforce. You can perform DML operation of salesforce objects from. Integrating with the WebMerge API is a great way to handle bulk document generation that can be automated within your systems. Build apps for the AppExchange D. net using soap api salesforce integration with. class simple_salesforce. On the other hand, Bulk API processes data in larger batches than Batch API, resulting in a lower API calls usage per operation on large volumes of data. the headers should be salesforce api field names in the csv file which you are trying to load. If we go step by step, we have to make 3 REST API call as follows: 1). We can move to next step which is to read actual data from Exacttarget API (i. You can find out more regarding the format of the results in the Official Salesforce. I have been through all documentation I can find on this including all of the official Salesforce Bulk API guides. NET applications using Web Services SOAP API. Bulk API and Lock Contention with Emely Patra REST API concepts and examples - Duration:. create_query_job(object_name, contentType='JSON') Using API v39. This example assumes a unique User record exists that has an Email value of “[email protected] com REST API Documentation. Support for Salesforce bulk API "Refresh Salesforce Metadata" feature makes it easy to update components to latest Salesforce metadata without having to delete and re-create them. Our system can generate millions of documents per day, so any high volume requests will not be a problem! Solutions for API Document Generation. The Salesforce Bulk 2. You can use it to modify a large number of records asynchronously by submitting batches from an Excel sheet. In this module we are going to discuss four different API’s. The PowerCenter Integration Service can use the Saleforce Bulk API to read data from Salesforce sources. com's bulk API, a great tool for updating large amounts of data in Salesforce. DocuSign Rooms bring people together in a secure digital space to complete complex agreements faster, involving multiple people, documents, and stages. according to their business need. Q&A for Work. Use it on the fly for ad-hoc queries, or as part of a more complex tapestry of platform features in a Slack app. Bulk API SOAP API may be more convenient to process multiple records ( it has the same method for one or multiple records DML operation while REST API has different resource for multiple records DML operation /composite/tree/ ) If you need to process huge amount of data, use Bulk API While it is possible to query or. If we go step by step, we have to make 3 REST API call as follows: 1). Each of your requests has a method (corresponding to HTTP method GET/PUT/POST/DELETE etc. The Einstein Platform Services APIs enable you to tap into the power of AI and train deep learning models for image recognition and natural language processing. com/profile/11701794963882085815 [email protected] The PowerCenter Integration Service can use the Saleforce Bulk API to read data from Salesforce sources. Before we begin, there are a set of prerequisites that you need to get done in order to run the sample or interact using the SalesForce API's. The Bulk API is optimized to process large sets of data. The easiest way to do this is just to supply username and password. gem salesforce_bulk_api. You can use IBM App Connect to pass key data between Salesforce and other apps – automatically, in real time. Data export from InfoSphere MDM also uses the MDM Connector stage with the Member read interaction (MDM member get) in InfoSphere DataStage®. Connect is able to use the Salesforce Bulk API to write changes to Salesforce provided a small set of requirements are met. If not provided default value used is ContentType. The Designer identifies related Salesforce objects based on relationships defined in Salesforce. The Bulk APIs require the name of the object identified within the cloud service and a. Standard & Bulk API. Use SOAP API in any language that supports Web services. 0 of the HubSpot-Salesforce connector package, the new HubSpot Visualforce window on your Salesforce page layouts will populate with information pulled directly from the corresponding HubSpot object record. REST API:-REST API is a simple and powerful web service based on RESTful principles. Salesforce Developer Network: Salesforce1 Developer Resources. You can use the activities of this palette to insert, update, or delete large sets of data. These include SpringCM user sync for Salesforce, bulk CSV upload, the SpringCM user interface, or the API. pdf), Text File (. JIRA REST API is protected with some restrictions, in order to proceed with the integration you have to authorize. This article explains how to connect to or integrate with Salesforce with C#. These include SpringCM user sync for Salesforce, bulk CSV upload, the SpringCM user interface, or the API. When can we use REST API ,SOAP API,BULK API and STREAMING API in Salesforce? Hi All, When can we use REST API ,SOAP API,BULK API and STREAMING API? please give suggestions. NET equivalent, which is possible with the CData ADO. For example, when a customer raise a support ticket via SMS, the inputs are captured within Salesforce as Case. One example is to group your data by a parent record like Account so that Bulk API jobs do not fail due to parent record locking. Customers can now focus on using Heroku Connect to build apps spanning Salesforce/Heroku without worrying about the volume of API calls. Its advantages include ease of integration and development, and it is an excellent choice of technology for use with mobile applications and Web 2. If you change the version, you also must download the relevant JAR files from Salesforce Web Services Connector (WSC). Finally and for compatibility reasons,. DocuSign is the market share leader in digital signatures (>70%) with over 300,000 companies & 200 million users: industry standard eSignature experience your customers will love. It adds some missing features of salesforce_bulk. com Bulk API. The Salesforce Bulk API palette is REST based. The following is for an enterprise account. For example, an API call to retrieve a ticket with an invalid ID will return a HTTP 404 status code to let you know that no such ticket exists. The Salesforce. create_queryall_job(object_name, contentType='JSON') Example. Among the above Salesforce api, today we will trying to cover the topic Salesforce rest api integration by taking example of two Salesforce systems. The Bulk API is optimized to process large sets of data. A Salesforce DX Plugin with different functionalities aimed at improving development and operational workflows - Accenture/sfpowerkit when retrieving in bulk -u. Import Accounts Using Bulk API and Workbench | Salesforce Trailhead Solution Jie Jenn. These include SpringCM user sync for Salesforce, bulk CSV upload, the SpringCM user interface, or the API. I need to regularly (Weekly) import automatically Contract data from an oracle database. Is there a way to do a bulk fetch of data with the Salesforce Connector? We want to minimize our API calls so we are planning on pulling the data with 1 call that we will then parse thru. Salesforce was the cheat code for us to roll that out. Open a new terminal window and run the following command to get the commands list. The Salesforce Bulk REST API is not currently available on the RapidAPI marketplace. If you do not provide an appid (see above) and you use this API at a very high rate (greater than 1 qps), we will have to blacklist you. Using the bulk api which is fully supported using the MuleSoft Salesforce connector you can automate the export of large number of records from sfdc as a csv or xml. It is common to use this API from mobile apps. com ') The examples so far would use the SOAP API for authenticating. Try our easy-to-use APIs, list processing tools and more. js, enables Salesforce application development in event-driven style. This triggers a notification email to the new Account Owner, giving them a long string as a reference, e. Use a Salesforce Lookup transformation to look up data in a Salesforce object. LastName FROM Account. Login to your Salesforce Customer Account. Now we are going to see how to do a call using REST API. The Salesforce. Obviously a lot of this is useless. The function is available if you have the Bulk API feature enabled. If you change the version, you also must download the relevant JAR files from Salesforce Web Services Connector (WSC). Generally, if utilizing the functions, such as [Bulk Write Data(Insert)], in order to perform job creation, batch creation, the obtainment of batch results, and job closing as bulk process, this component does not need to be used. Then you add one or more batch to the job, identified by the Job ID. I am looking for SalesForce Bulk API client to perform big data load/upload. 0 simplifies uploading large amounts of data by breaking the data into batches automatically. Bulk API has some restrictions, for example: related objects exports are not supported by this API. Connect is able to use the Salesforce Bulk API to write changes to Salesforce provided a small set of requirements are met. Whenever the Bulk API checkbox is left unchecked, the Batch API is in use. Its advantages include ease of integration and development, and it is an excellent choice of technology for use with mobile applications and Web 2. For example, you can create, read, update, and delete (CRUD) records, search or query your data, retrieve object metadata, and access information about limits in your Salesforce org. Bulk API is not supported using SOAP. The data landscape is more varied than ever with unstructured and structured data originating from many cloud and on-premises sources. It uses Key based Lookup. SSIS Upsert Destination Example – Bulk Insert or Update in SQL Server (Merge Records) Salesforce BULK Update Feature. You can monitor a Bulk API batch in Salesforce through the Job ID for the Bulk Data Load Jobs. General Data Protection Regulation (GDPR) On May 25, 2018, a new privacy law called the General Data Protection Regulation (GDPR) takes effect in the European Union (EU). There are 2 possible ways to achieve this. Then how does the Bulk API work and when we can suggest BULK API or Standard API to client. Prerequisites. It is common to use this API from mobile apps. Anypoint Platform, including CloudHub™ and Mule ESB™ , is built on proven open-source software for fast and reliable on-premises and cloud integration without vendor lock-in. NET Provider for Salesforce. If the number of results returned by a query is greater than or equal to this value, and Bulk API queries is enabled, then the Simba Salesforce driver attempts to use the Bulk API for data retrieval. How to connect your app to Salesforce using Auth0. NET based application through the salesforce SOAP API. This is a step-by-step guide with screenshots tat will tell you how to download, install, configure and create everything that you need for this. Job specifies the type of operation and Object used to process records. This approach helps to keep the web API intuitive. com data into our system, Accounts for example. You can use the activities of this palette to insert, update, or delete large sets of data. SOAP API provides 2 methods (getUpdated() and getDeleted()) which can be used to backup data which is changed. Salesforce Developer Network: Salesforce1 Developer Resources Use the following examples to understand how to do tasks with Bulk API 2. 405: Method not allowed: This API request used the wrong HTTP verb/method. com's bulk API, a great tool for updating large amounts of data in Salesforce. For example, /customers is the path to the customers collection, and /customers/5 is the path to the customer with ID equal to 5. com much more quickly than we can using the Standard API, and second, we get feedback directly from Salesforce. A bulk query can retrieve up to 15 GB of data, divided into 15 1-GB files. For new users, try the above example to get started, and for others, please share with us how you plan to use Bulk API v2. Access latest { BatchInfo} of a submitted { BatchInfo}. Bulk API is basically used when you are dealing with really large datasets. Export data from Eloqua. like why do we need to use batch apex against dataloader. Marketo exposes a REST API which allows for remote execution of many of the system’s capabilities. Salesforce Batch API is based on SOAP principles and is optimized for real-time client applications that update small numbers of records at a time. Before we begin, there are a set of prerequisites that you need to get done in order to run the sample or interact using the SalesForce API's. New data synchronization. The Bulk API can process up to 10,000 records in a batch and up to 2000 batches per 24-hour period. For example, the source table includes the employee ID, but you want to include the employee name in the target table to make summary data easy to read. Salesforce will process these batches in the background until they are all complete. The job specifies which object is being processed and…. No parameters are required in this API. It adds some missing features of salesforce_bulk. I can provide/attach a pdi job that walks through each of these requests if someone can help package into a single step. 0, you can use Lightning Knowledge in addition to Knowledge in Salesforce Classic. com and Bulk API Query with Primary Key (PK) Chunking It takes some grit work to get a mass amount of data from Salesforce. Use a Salesforce Lookup transformation to look up data in a Salesforce object. With Azure Logic Apps and the Salesforce connector, you can create automated tasks and workflows for your Salesforce resources, such as records, jobs, and objects, for example: Monitor when records are created or changed. When you upgrade to version 3. Sample value: true The number of seconds to wait for a connection during API calls. Bulk API and Lock Contention with Emely Patra REST API concepts and examples - Duration:. The Anypoint Salesforce Connector lets you connect to the Salesforce SOAP API, REST API, Bulk API, and Streaming API, depending on the operation you configure. Thanks Help & Training Rest API Salesforce Bulk API Salesforce SOAP API Streaming API. 0 in this module because it’s a bit easier to use. Support for calling any Salesforce SOAP API (XML API) Call REST Style HTTP Web Service from SSIS (e. You can use SOQL in java-script on your VF pages or any kind of java-script that you write, like we can get it executed on click of a button or link present on your detail page of a record. Bulk API 2. Super-charge your team. " Connection timeout (sec) Optional: Only environment variables are available. Sample value: false Select this option to use Bulk API to upload zip files containing binary attachments, such as Attachment records or Salesforce CRM Content. node-salesforce. This triggers a notification email to the new Account Owner, giving them a long string as a reference, e. Batch sizes should be large enough to minimize the overhead processing cost and small enough to be easily handled and transferred. Net This is in continuation from my previous post where I had explained how to fetch data from SalesForce using the SOAP API. com functioning with an existing Microsoft SQL Database. Verify bulk API is also enabled in Salesforce. 1) One Trigger Per Object A single Apex Trigger is all you need for one particular object. salesforce integration with. SOAP API: This API is useful to integrate your Salesforce organization data with other application using SOAP. Marketing, Sales and Projects together at last on one cloud-based unified platform. 11) How to implement Salesforce to Salesforce connection? Answer: Enable SF to SF connection in Customize and then invite other SF company. Trailblazers succeed with Pardot. The following downloadable source code contains a working example of uploading files over REST. Read More!. Create a new Job. NET applications using Web Services SOAP API. Email fields for each record. Use the Lightning Knowledge API Starting with API 39. Node-Salesforce) is a isomorphic JavaScript Library utilizing Salesforce's API: It works both in browser and with Node. In this tutorial, I will show you a quick example on how you can use Salesforce as the identity provider to access API Cloud web applications. For new users, try the above example to get started, and for others, please share with us how you plan to use Bulk API v2. com much more quickly than we can using the Standard API, and second, we get feedback directly from Salesforce. You want to load tons of data into Salesforce. Installation. For example, if you import Opportunity as a source, you can also import fields of the following child related objects:. I am looking for SalesForce Bulk API client to perform big data load/upload. To include a single quotation mark in a query string, it must be prefaced by another. The Salesforce connector provides the Create and Create Bulk operations for working with the Bulk API. The figure shows the content of the OSGi bundle of the. This time, I’ll share my experience getting Mutual Authentication working with the Java client SDK for Salesforce’s SOAP and Bulk APIs: Web Service Connector, aka WSC. Bulk API has some restrictions, for example: related objects exports are not supported by this API. API permission must be enabled in Salesforce. Step-2 : Read data from Salesforce Marketing Cloud API (SSIS JSON Source) Now once we have token extract step done. The fact-checkers, whose work is more and more important for those who prefer facts over lies, police the line between fact and falsehood on a day-to-day basis, and do a great job. Today, my small contribution is to pass along a very good overview that reflects on one of Trump’s favorite overarching falsehoods. Namely: Trump describes an America in which everything was going down the tubes under  Obama, which is why we needed Trump to make America great again. And he claims that this project has come to fruition, with America setting records for prosperity under his leadership and guidance. “Obama bad; Trump good” is pretty much his analysis in all areas and measurement of U.S. activity, especially economically. Even if this were true, it would reflect poorly on Trump’s character, but it has the added problem of being false, a big lie made up of many small ones. Personally, I don’t assume that all economic measurements directly reflect the leadership of whoever occupies the Oval Office, nor am I smart enough to figure out what causes what in the economy. But the idea that presidents get the credit or the blame for the economy during their tenure is a political fact of life. Trump, in his adorable, immodest mendacity, not only claims credit for everything good that happens in the economy, but tells people, literally and specifically, that they have to vote for him even if they hate him, because without his guidance, their 401(k) accounts “will go down the tubes.” That would be offensive even if it were true, but it is utterly false. The stock market has been on a 10-year run of steady gains that began in 2009, the year Barack Obama was inaugurated. But why would anyone care about that? It’s only an unarguable, stubborn fact. Still, speaking of facts, there are so many measurements and indicators of how the economy is doing, that those not committed to an honest investigation can find evidence for whatever they want to believe. Trump and his most committed followers want to believe that everything was terrible under Barack Obama and great under Trump. That’s baloney. Anyone who believes that believes something false. And a series of charts and graphs published Monday in the Washington Post and explained by Economics Correspondent Heather Long provides the data that tells the tale. The details are complicated. Click through to the link above and you’ll learn much. But the overview is pretty simply this: The U.S. economy had a major meltdown in the last year of the George W. Bush presidency. Again, I’m not smart enough to know how much of this was Bush’s “fault.” But he had been in office for six years when the trouble started. So, if it’s ever reasonable to hold a president accountable for the performance of the economy, the timeline is bad for Bush. GDP growth went negative. Job growth fell sharply and then went negative. Median household income shrank. The Dow Jones Industrial Average dropped by more than 5,000 points! U.S. manufacturing output plunged, as did average home values, as did average hourly wages, as did measures of consumer confidence and most other indicators of economic health. (Backup for that is contained in the Post piece I linked to above.) Barack Obama inherited that mess of falling numbers, which continued during his first year in office, 2009, as he put in place policies designed to turn it around. By 2010, Obama’s second year, pretty much all of the negative numbers had turned positive. By the time Obama was up for reelection in 2012, all of them were headed in the right direction, which is certainly among the reasons voters gave him a second term by a solid (not landslide) margin. Basically, all of those good numbers continued throughout the second Obama term. The U.S. GDP, probably the single best measure of how the economy is doing, grew by 2.9 percent in 2015, which was Obama’s seventh year in office and was the best GDP growth number since before the crash of the late Bush years. GDP growth slowed to 1.6 percent in 2016, which may have been among the indicators that supported Trump’s campaign-year argument that everything was going to hell and only he could fix it. During the first year of Trump, GDP growth grew to 2.4 percent, which is decent but not great and anyway, a reasonable person would acknowledge that — to the degree that economic performance is to the credit or blame of the president — the performance in the first year of a new president is a mixture of the old and new policies. In Trump’s second year, 2018, the GDP grew 2.9 percent, equaling Obama’s best year, and so far in 2019, the growth rate has fallen to 2.1 percent, a mediocre number and a decline for which Trump presumably accepts no responsibility and blames either Nancy Pelosi, Ilhan Omar or, if he can swing it, Barack Obama. I suppose it’s natural for a president to want to take credit for everything good that happens on his (or someday her) watch, but not the blame for anything bad. Trump is more blatant about this than most. If we judge by his bad but remarkably steady approval ratings (today, according to the average maintained by 538.com, it’s 41.9 approval/ 53.7 disapproval) the pretty-good economy is not winning him new supporters, nor is his constant exaggeration of his accomplishments costing him many old ones). I already offered it above, but the full Washington Post workup of these numbers, and commentary/explanation by economics correspondent Heather Long, are here. On a related matter, if you care about what used to be called fiscal conservatism, which is the belief that federal debt and deficit matter, here’s a New York Times analysis, based on Congressional Budget Office data, suggesting that the annual budget deficit (that’s the amount the government borrows every year reflecting that amount by which federal spending exceeds revenues) which fell steadily during the Obama years, from a peak of $1.4 trillion at the beginning of the Obama administration, to $585 billion in 2016 (Obama’s last year in office), will be back up to $960 billion this fiscal year, and back over $1 trillion in 2020. (Here’s the New York Times piece detailing those numbers.) Trump is currently floating various tax cuts for the rich and the poor that will presumably worsen those projections, if passed. As the Times piece reported: