pipedrive | Complete Pipedrive API client for PHP | REST library

Presuming your target is as csv/spreadsheet entries

It is best to tackle the task in stages, and my preferred target format is CSV for a spreadsheet

TL;DR see last comment

I believe your goal is as follows.

• Your provided python script works fine.
• You want to convert your python script to Google Apps Script.

• Your python script requests the PUT method. But your Google Apps Script requests the POST method.
• In the case of {field_name: todays_date}, the key is always "field_name".

When these points are reflected in your script, how about the following modification?

Your more_items_in_collection case never resolves the promise. It just creates a new one, then does nothing with it.

Additionally, you're making your code more complicated than it needs to be by using new Promise. Axios already returns a promise, so there's no need to explicitly create a new one. Calling .then will create a new promise automatically, which resolves to whatever value you return in the callback.

I believe your goal as follows.

• You want to retrieve the value of label using key and id from the JSON object in your question using Google Apps Script.
  • As a sample situation, you want to retrieve the value of "label": "Expired" using "key": "c4ecbe01c34994ede3a50c0f8" and "id": 28.
• The JSON object has the arrays of data and options. Both arrays have the several elements.

• If dealFieldsresponse is the JSON object in your question, dealFieldsresponse.data and dealFieldsresponse.data[].options are 1 dimensional array. When you want to retrieve the value of key and id, it is required to loop those arrays.

When above points are reflected to your script, it becomes as follows.

personArray returns:

[John Smith, [555-867-5309, 444-867-5309], [john@gmail.com, john@yahoo.com]]

but your goal is to return:

[[John Smith, 555-867-5309,444-867-5309, john@gmail.com,john@yahoo.com]]

where 555-867-5309,444-867-5309 and john@gmail.com,john@yahoo.com is a single string element separated by comma.

To convert: ['555-867-5309', '444-867-5309'] to '555-867-5309,444-867-5309' you can use Array.prototype.toString().

Replace:

var personArray = [name, phone, email];

with:

var personArray = [name,phone.toString(),email.toString()]

Complete snippet:

With your original approach, exchanging $eq with $in should work, and since you only have one condition $and is not necessary. Note that $deals_id should exists in foreign document and must be an array, as $in requires the second parameter to be an array. So in case it doesn't exist we will have to wrap it with $ifNull

To achieve this you can send custom field key - value pairs just in the request body.

According to this example:

Try with the below xpath where we are normalizing the white spaces in the class.

If the widget is in the iframe then you require either:

• GTM in the iframe, not just the parent window
• The post message api to securely call functions between the iframe and parent window (the parent window being where GTM is loading)

If the css you are targeting is in the iframe then you need to treat it as a different website that doesn't have your GTM container loaded on it.

If you're trying to move the iframe to the bottom left then this is working for me in a jsfiddle: