community.jitterbit.com Open in urlscan Pro
35.158.127.53  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Loading
×Sorry to interrupt
CSS Error

Refresh
Skip to Main Content
1.877.852.3500
 * Login


SUBMIT FEEDBACK

How would you rate this site?
How_would_you_rate_this_site__c
Great


Feedback
CancelSave



WELCOME TO THE


JITTERBIT COMMUNITY FORUMS




 * Posted on Oct 25, 2024 3:28:00 AM by kishore reddy
   
   
   JITTERBIT NOT UPDATING ALL ID INTO SALESFORCE
   
    * Hi, I am trying to integrate data form salesforce to workday. step 1:
      Jitterbit is pulling data from salesforce to workday and inserted 2
      records. It is fine. step 2: afte... er successful, we are updating the
      workdayId into salesforce. Here only one recordId is updating in
      salesforce. In source transformation showing 2 records and in target
      transformation its showing only one record  More >
   
    * forumComments [1]

 * Posted on Oct 24, 2024 11:40:06 PM by PaulN
   
   
   DUPLICATE GLOBAL VARIABLE
   
    * Hi, One project seems to go corrupt, with a global variable appearing many
      times. Please see screenshot attached. Can't delete the 'extras'. Thanks
      Paul
   
    * forumComments [1]

 * Posted on Oct 21, 2024 1:40:06 AM by Gus
   
   
   EMPTY JSON RESULTSET
   
    * Hi everybody. Using Integration Studio not design studio.. I have noticed
      a really unfortunate bit of behaviour scripting in a transformation from
      an HTTP endpoint, when a... an empty result set comes back. I have made a
      call to an HTTP endpoint that returns JSON data. In the transform after
      the call I am attempting to discover if there is a result. The returned
      data is in the form when there IS data to return { "courses": [ { "id":
      1234, "fullname": "Blah", "snakes": "Ladders" } ], "warnings":[] } If
      there is no data associated with the request I have ( In postman) got the
      following return { "courses": [], "warnings": [] } I am trying to detect
      this empty dataset, and act on the fact that it is empty. The transform is
      to a flat file.. If in the scripting I start
      WriteToOperationLog("Transformation Starting"); Then attempt to access
      json$courses$item.id either directly or checking for Null,Empty or even
      length of json$ or json$courses$ or json$courses$item to log a response,
      then it even kills the logging of the "Transformation Starting".. How do I
      detect and then Act on the Absence of data in a result set ??  More >
   
    * forumComments [1]

 * Posted on Oct 18, 2024 10:00:40 AM by rmoody
   
   
   I NEED TO RENAME A FILE IN AN SFTP IN PLACE (ENTIRELY WITHIN THE SFTP
   SERVER).
   
    * The requirements I was given were to create the file with a temp name and
      then rename it after it's already been saved to the SFTP server. The
      reason given is to avoid process... sing partial files. I know I can uses
      sources and targets to pull those files, change them, and send them back,
      but is it possible to just rename a file that's already on an SFTP server?
      If so, how might I accomplish that  More >
   
    * forumComments [1]

 * Posted on Oct 5, 2024 6:43:31 AM by PaulN
   
   
   DECODING BASE 64
   
    * Hi, I have a var that is base64 encoded. The content is a binary image
      file. How can I decode it to the original binary data? Regards Paul
   
    * forumComments [1]

 * Posted on Sep 30, 2024 11:28:49 PM by PaulN
   
   
   SSL JIRA CONNECTION AND HTTP JIRA CONNECTION SSL PROBLEM
   
    * Hi, I have an integration with 2 Jira endpoints to the same Jira system.
      One is an HTTP connector, and it works. The second is the blue out of the
      box Jira connector, and i... it throws the error "No trusted certificate
      found". Any ideas? Thanks Pau  More >
   
    * forumComments [4]

 * Posted on Sep 27, 2024 8:46:38 PM by Meyananth
   
   
   JITTERBIT HARMONY - WANT TO MAP SYSTEM.ASSIGNEDTO (ADO -OOTB) FIELD WITH
   ASSIGNEE FIELD IN HELIX ITSM
   
    * Hi Team, I would like to map the AssignedTo from ADO to Assignee field in
      Helix ITSM using the OOTB Template. From Azure DevOps (ADO), we are
      getting the Assig... gnedTo field with the below format.
      "System.AssignedTo": "Full Name <Email Address>" When we map this field to
      our Assignee field in the Transformation and the Assignee field is
      receiving it as {email address}. Is there a way to process the data to get
      the Full Name instead of Email Address? Any inputs will help!  More >
   
    * forumComments [0]

 * Posted on Sep 2, 2024 3:16:55 AM by Irfan
   
   
   PARTICULAR TRANSACTION GOES INTO RUNNING STATUS
   
    * Hi, The Project Transaction gets stuck Goes into Running Status for a Long
      time unless it is Cancelled, I tried Upgrading agent still facing the same
      issue but the number of... f transaction goes into Running status had
      reduced than before. Let me know if anything can be done on this issue? It
      is a Private Agent- Linux OS, Version 11.2  More >
   
    * forumComments [3]

 * Posted on Aug 29, 2024 8:24:49 AM by imohamed
   
   
   SPLITTING OUTPUT FROM QUERY AND THEN LOOPING THROUGH THEM FOR SALESFORCE
   
    * Hello, I have a workflow that gets triggered by an incoming API that
      Jitterbit hosts. The workflow triggers as expected and I can then read the
      payload. I store the payload ...  in a global variable which is in a JSON
      format. I parse out the different fields and perform a SFDC query to get
      back a single contact id and perform a SFDC query on that and get an ID
      back. I then have a list of product names that I need to perform a lookup
      on. I perform a 'Read' of the global variable and get the product names
      that I need to lookup. I now need to send each of these product names to
      Salesforce for a lookup to get the Product Id back. This is where I do not
      know what to do. Here are my steps and code used: 1. "Read" Payload from
      global variable 2. "Transformation" of JSON format into a flat structure.
      I grab the list of Product names 3. I "Write" the product names into a new
      global variable 4. This is where I need some help to parse the out the
      product names so I can loop through them and call a runoperation on
      another activity that can then give me the ids back. How can I parse out
      the variable with the product names? When they come back from Jitterbit,
      is there a character I can 'split' on? Currently if I write out the
      content of the log I see that each of the product names are on separate
      lines. This is the code I want to perform : $counter = 0; myprods =
      split($ProductId, "/n"); // What do I split on? Tried different chars but
      no luck lenProdArray = length(myprods); while(lenProdArray < counter,
      WriteToOperationLog("Starting loop with Product: " + $myprods[counter]));
      RunOperation("<TAG>operation:get product id</TAG>"); $counter = $counter +
      1); Each of the product names I need to get the Id back as this ID has to
      be written to another SF table. I have other activities that write back
      the other tables (opportunity and Opportunity Product) so that I have
      resolved. Thanks  More >
   
    * forumComments [1]

View More


TOPICS BY CATEGORY

 * Management Console


 * 
 * 1.877.852.3500
 * 1301 Marina Village Parkway
   Suite 201
   Alameda, CA 94501
 * info@jitterbit.com

 * 
 * 
 * 

Copyright © 2024 Jitterbit, Inc. Privacy Policy




Loading