sfid | Work easily with Salesforce Ids in Node.js | Runtime Evironment library

1. I have below json response array which I am getting into Jmeter Regular expression extractor variable C_Totalresponse.

2. In this I have cartItems JSON object.

3. In the cartItems JSON object, we have different SKUs and corresponding quantities.

4. I'm using a hashmap to read values from a CSV file and update quantity details for each SKU, but my script is failing at fetching response into array in Jmeter.

5. I'm sharing the Jmeter code and error I faced while parsing JSON array at the end

I see many post suggesting groovy I am not sure how to use it for huge response like this

...

I am always getting postgresql error on sfid field because of unique restrictions after mapping and a bad SF synchronisation (so that field stay blank).

After second SF synchronisation errors I can't save other row.

Please help

...

The below one is my keyvalue pair String. I've tried many ways but not able to solve it. here i can't do any split by comma or replacement with other String. the result i got from below code and libraries are:

...

I am pulling file list on spreadsheet and some folders will take 1 hour to get all the data. How can I exceed my time limit to get all the data? Currently limit is 30mins.

Here is my code:

...

I have got two tables below (examples):

Table SFID

Sales Force ID Type Name Assistant From To 123 ABC Store A Ben 01/04/2020 30/04/2020 123 ABC Store A Jen 01/05/2020 31/05/2020 123 ABC Store A Ben 01/06/2020 21/06/2020 126 DEF Store B Tim 01/04/2020 30/04/2020 126 DEF Store B Tim 01/04/2020 null

and

Table Activity

Transaction ID Date Sales Force ID 1 03/05/2020 123 2 03/06/2020 200 3 01/01/2021 123 4 02/01/2021 126

I want my end result to be

Transaction ID Date Sales Force ID Type Name Assistant 1 03/05/2020 123 ABC Store A Jen 2 03/06/2020 200 null null null 3 01/01/2021 123 null null null 4 02/01/2021 126 DEF Store B Tim

To do this, the best solution was the one posted in here with some modifications (allow both To and From to be null). However, only the row on transaction ID 2 disappears because that Sales Force had already had assistant entries (they get wiped out on the filtered row step). I also tried the solution presented in here but it takes ages to load.

I would like to know if there was a way to guarantee all transactions appear without having to introduce lines to table SFID for periods they don't have assistants and without making the query a really slow one.

This is my code:

...

TLDR; Proxysql isn't sending any data to or replicas. The master works just fine, and the replicas are all caught up, but they aren't serving traffic.

Overview: The main issue is that no traffic is going to the replicas:

• We have 4 mysql clusters. Each one has a master, and two replicas.
• The replicas are all caught up to master and replicating fine.
• We are on... Drupal (sigh) for now, so we have multiple databases per cluster. All with their own proxysql user and default host group.
• Proxysql shows null on connection errors to the replicas. It looks like it can connect.
• But all the traffic just hits the master. It serves all select, update, and delete statement.
• We have our masters and replicas set up in their own write and read groups (not in the same host group as we'd prefer to manually dictate which is a master and which are replicas).

Question: How do we get data hitting our replicas and not just the master?

Configs:

...

I have a for loop query and i am trying to change it without looping and trying to one record to validate with out looping.

so, i am looking for normal query without looping.

...

I want to start from a vertex, follow outward edges, till I reach a "leaf" vertex, having no more out edges.

I tried

g.V(2).repeat(out().not(hasLabel('region', 'business')).simplePath()).until(outE().count() == 0 )

I couldn't figure out what to pass in until, all examples i found were passing "has" or similar testing a property on the vertex.

I am trying in the Gremlin Console, but will also need it to work from a java application.

Sample Graph :

...

I was trying to merge two table from different server in postgres. But it keep saying I have syntax error

...