sugarcrm | A ruby based REST Client for SugarCRM

I have a data frame with 4 columns that contain job titles. For each column, I want to create a new column (category1, category2, category3, category4) which assign each job a category 1-10 depending on which words the job titles contain (e.g. if the job title contains the words "frontend", "ui", "ux" then the column category1 should say 1). I managed to do the categorizing manually for each column using the following code but want to do it at the same time for all 4 columns. Any help is appreciated!

I would like to apply multiple gsub functions to all 4 columns of the data frame and already tried it in the following way but it didn't work, any ideas on how to solve this? Thank you!

I am trying to get the second last value in each row of a data frame, meaning the first job a person has had. (Job1_latest is the most recent job and people had a different number of jobs in the past and I want to get the first one). I managed to get the last value per row with the code below:

first_job <- function(x) tail(x[!is.na(x)], 1)

first_job <- apply(data, 1, first_job)

I have a SugarCRM 6.5 application. I have to trigger an email using after_save hook when a record is created(not during update).

I know I can use the workflow. But I can't use the workflow for this scenario due to multiple reasons.

Now I need to know how to find if the record is just created or is it being updated from after_save hook file?

Using a suiteCRM query that connects with sugarCRM i need to retrieve all the opportunities that have an specific user and client id, being the client id (account_id) not queryable (at least directly).

So this means that i cannot use a syntax like this one:

I have a website that pulls customer cases from our CRM (SugarCRM) the cases and case notes can have attachments which are stored in the CRM. Sugar has a built in API endpoint to get the file data and return it via a curl request using:

//:record/file/:field as a GET request

my curl script

Is there a restriction on the file size to send through the REST API?

I have a file field in a web form in my Drupal Website and sending the uploaded file to the SugarCRM application through REST API using base64_encode function.

This is working fine for the small files. But when we try to upload files around 2 MB the file, it is sending an empty value.

Is there a limit on file size that can be sent through REST API? If so, is there any other way I can send a big file(at least 2MB) to my SugarCRM application?

Google did not help me this time. If someone could, that would be great.

I have a Webform on my Drupal website(8.8.5). The Webform has multiple fields along with two file fields.

When the user submits the Webform, I want to send the details to an external API (SugarCRM) including the files attached in the Webform.

How can I do this? Is there a module available in Drupal 8 to achieve this easily? Or do I need to handle the data submitted and call the API manually?

I also would like to store the data on the website as it works usually.

I have a function in PHP which calls another class function in order to assign a value to one of it's variables $related.

The original function requiring the value uses the requestACLForAccess() function to add a specific variable filter to the $headers variable:

The listRecords function: