Questions tagged [jitterbit]

Jitterbit is a suite of data integration products with two main components: Jitterbit Integration Environment and Jitterbit Integration Server. Use this tag for questions about the Integration Environment and Server, including building, testing and deploying Data Transformations, Formulas, Projects, Jitterpaks and Plug-ins.

Jitterbit is a suite of data integration products with two main components: Jitterbit Integration Environment and Jitterbit Integration Server. Use this tag for questions about the Integration Environment and Server, including building, testing and deploying Data Transformations, Formulas, Projects, Jitterpaks and Plug-ins.

Useful links:

66 questions
0
votes
1 answer

Download Multiple Attachments from Salesforce using Jitterbit

I am able to create a query for attachments and download 1 individual file like this: SOQL: SELECT Body, Id FROM Attachment WHERE Id = '00P4M00000q8ChI' Code on Body: $content =…
0
votes
1 answer

How to make a web service call to Salesforce from jitterbit

I am new to Jitterbit and i want to update records in salesforce based on a condition but need to do this using a web service. Using web service i want to get the id of the record from salesforce as a response then that response will be used as a…
nainika
  • 1
  • 1
0
votes
1 answer

Jitterbit issue setting xsd file as Target of Transformation

I have a DB->XML Transformation and I have the DB Source set up. But trying to set the Target XML to my XSD file is giving me the following error: The uploaded file named "My.xsd" has a problem: The uploaded file includes a file which uses an…
Rob H
  • 11
  • 2
0
votes
1 answer

How to use Composite API in Jitterbit for inserting records in Salesforce?

I need to insert records for Account and contacts in one go using Jitterbit, i have one flat file with all the infomation but i dont have external ids. So, i want to use Composite API SFDC in jitterbit for this operation. So, anyone can help me with…
nainika
  • 31
  • 1
  • 7
0
votes
1 answer

Counting items in Jitterbit JSON transformation

I am trying to create a Jitterbit condition which depending on the json passed into it will call one of two operations if true or false. The previous transformation filters the JSON using a transformation condition so if a certain piece of data…
Martin R
  • 55
  • 1
  • 7
0
votes
1 answer

Jitterbit export to csv with header

Using Jitterbit studio 8.26.1.2. Trying to transfer data from db to csv. It works but the csv file does not have headers. Would like to have header with names as in the source table. would like: id,fname,lname 1,John,Smith 2,Theresa…
Rafal
  • 1
  • 1
0
votes
2 answers

Environment on Jitterbit Harmony does not show up in Jitterbit Studio

I am new to Jitterbit. I was given the access to an environment which shows up in Jitterbit Harmony website - Environments. However after logging into Jitterbit Studio on my desktop (with internet connection, refreshed), I cannot find that…
MM Cui
  • 51
  • 6
0
votes
1 answer

How to archive a file in jitterbit

I don't want to specify any specific file name in the source or target instead I would like to use a placeholder something like $filename.txt or [filename].txt filename is a global variable in my operation and I need to move this file between…
user1176058
  • 642
  • 1
  • 8
  • 21
0
votes
1 answer

How to get the file name that is currently processing in Jitterbit

I have a source that maps to a folder that has all .txt files. I have a transformation that picks a file and targets an web api end point. Now how to I get the file name that I just transformed.
user1176058
  • 642
  • 1
  • 8
  • 21
0
votes
1 answer

JitterBit Run Only One Instance of an Operation at a Time

I ran into an issue where I had long running JitterBit operations that were scheduled. I had them scheduled close together, since I needed to keep data flowing. But, when they would take longer than expected I would wind up with multiple instances…
w3bguy
  • 2,215
  • 1
  • 19
  • 34
0
votes
1 answer

Jitterbit data loader giving issue while fetching attachment from salesforce

Jitterbit data loader giving access issue while fetching attachment from salesforce. I'm able to fetch .pdf and .jpeg files from salesforce but it is giving access issue while tetching .csv and flat files from salesforce to other system. Below is…
0
votes
1 answer

Jitterbit Formula Builder - Case inside IF?

I was wondering if you can use the 'case' function within an If statement in the Jitterbit formula builder? We have 2 different source fields mapped to a target field in salesforce. Im using the case to say if a particular set of characters are…
Andrew Hoban
  • 43
  • 1
  • 4
0
votes
1 answer

Operation is not allowed - Picklist value Salesforce API

I have a simple upsert operation using the Jitterbit data loader. I am trying to create a new case record in Salesforce. One of the attributes of the case object is the case origin. This is a picklist field. I want all case objects created using…
dior001
  • 751
  • 1
  • 13
  • 32
0
votes
1 answer

How do I get a Jitterbit hosted HTTP Endpoint [servername] and [port]?

I am creating an operation in Jitterbit containing a Hosted HTTP Endpoint. It should listen to a SFDC outbound message. Before you can download the SFDC WSDL, it requires you to map out the listening servername and port (jitterbit). As a matter of…
0
votes
1 answer

Will Data Loader for Salesforce 5.x End of life with Cload Data Loader 6.x 4/15/2015?

It was announced Data Loader 6.x will reach End of Life on April 15, 2015 and will cease to communicate with the Harmony Cloud. Causing existing operations to stop running. We have still have jobs running on Data Loader for Salesforce 5.x. Will it…
pwDev
  • 945
  • 8
  • 13