since ‎05-02-2019
8 hours ago
szymons55769873
Level 2
Batch size in Update data activity
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hi According to the documentation "Batch size" option translates into:The Batch size field lets you select the number of inbound transition elements to be updated. For example, if you state 500, the first 500 records dealt with will be updated. Which sounds a bit misleading... It sounds like when I have batch size set to 10 000 and the number of inbound records is 10 100 I will be missing 100 records in the target schema, which sounds ridiculous. Could somebody elaborate on this option? Thanks

Views

114

Likes

0

Replies

1
Deduplication - keep the records with the smallest value doesn't work
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hi I'm using a deduplication activity and choosing 2 fields to base the deduplication on, in the next step, I choose a field that differentiate the records, which a numeric value. When I pick "Using an expression" method and choose the field and the option to Keep the records with the smallest/largest value I doesn't work - it picks the last (if largest is chosen) or first (if smallest is chosen) record from the duplicates from the previous transition, totally disregarding the value in the field...

Views

1.4K

Likes

0

Replies

1
Re: Export 'subject' (or in general XML field) in export template
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hi All It is often indicated that whatever workaround will be used to extract/insert subject line there is still a problem of that subject line being BEFORE personalization (so any dynamic parameters in subject will be there as plain text). Has anybody figured out a way to obtain the subject that is AFTER personalization step and has all the dynamic parameters changed to actual DB values? @Jean-Serge_Biro @Amit_Kumar

Views

4.3K

Likes

0

Replies

0
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
But to access the page if logon is required you still need to have your IP whitelisted, which would address most of the vulnerabilities, wouldn't it?

Views

8.6K

Likes

0

Replies

0
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Amit, do you know if JS server pages have any limitations as such, or is in theory possible to read/write the exact same range of schemas and use all methods that SOAP Call allows?

Views

8.6K

Likes

0

Replies

0
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Thanks, Amit, would you know how exactly does the "Restriction by folder" option in the account settings in client work? It doesn't seem to work for API which is unfortunate

Views

8.7K

Likes

0

Replies

0
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Amit, I tested a scenario when the IP I whitelisted wasn't given API access rights and I was still able to obtain data from JSSP. A problem only would arise if the user was using an IP that has to have the API enabled.

Views

8.7K

Likes

0

Replies

0
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Thanks Amit for your thoughts. My idea was to create JSSP pages and instead of SOAP Calls allowing POST requests through HTTP, then I believe it would be possible to build some kind of basic tracking on that JSSP, wouldnt it?

Views

8.7K

Likes

0

Replies

9
Re: Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
@wodnicki Thanks, I'll check that out. As for the "nothing else", I would also like to limit one's ability to use factory schemas like xtk:session's methods, because if the user has access to those, he'd be able to do Write, so essentially insert/delete as well. Also, what do you mean by cosmetic and what does the documentation mean by "This restriction applies only to non technical users: a technical user, with related permissions, or using a workflow, will be able to retrieve and update data."...

Views

1.3K

Likes

0

Replies

0
Limit API Access to an account
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hello I was wondering if there is a possibility to limit account's access rights in a way that would allow only reading ONE particular schema and nothing else. Either SOAP API or jssp is fine.Additionally, is it possible to track exactly how often and how much data the user is obtaining with the API calls? Kind regards

Views

10.4K

Likes

0

Replies

13
array_agg postgresql in AC
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HelloIs it possible to group (concat) certain string values in one column by common value in other column in AC Classic? I've tried with Group By but it's for numerical aggregates and there's a function in postgresql which does that (array_agg) and wondering if it's possible somehow to emulate it with activities? (Having in mind that with SQL Activity it's not possible to make outbound transition with select results)Eg.City | Country------------------------------Madrid SpainBarcelona SpainParis ...

Views

657

Like

1

Replies

1
Re: Create a custom SOAP method that would send a delivery to recipients passed in the parameter (list of IDs)
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hi J-Sergethanks for inputs, much appreciated.How do I re-define the length of string in the method declaration in schema if the param element doesn't allow length as attribute?Strange thing is that I just sent more than 30 000 chars in pure "string" in param and it went through without problem. Sky is the limit? Unlikely for a string I suppose.

Views

1.4K

Likes

0

Replies

0
Re: Create a custom SOAP method that would send a delivery to recipients passed in the parameter (list of IDs)
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hello Jean BironThanks for the hints, it's been really helpful.Do you know perhaps what is the char limit in the parameters passed? There might be quite a bit of IDs passed there and I'm wondering if fitting them in single parameter delimited with comma is right approach.

Views

1.0K

Likes

0

Replies

0
Create a custom SOAP method that would send a delivery to recipients passed in the parameter (list of IDs)
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HiI am wondering if it's feasible to create a custom SOAP method that would trigger a delivery from a delivery template to the recipients whose IDs would be passed in the method as parameter (I guess a comma separated list in single parameter)?Any hints on how to achieve thatKind regards

Views

2.9K

Like

1

Replies

4
Timezone problemsf
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HelloI'm trying to run a workflow based on an option that stores the last run of the workflow.I'm querying the Recipient tracking logs for "logDate" and comparing that with the option as "on on after"I have a delivery that has its tracking logs all on 8:ish, so 8:05, 8:30 and 8:55.The option is, double confirmed in the workflow log, set at "Mon Jul 08 2019 09:28:53 GMT+0100 (BST)".When I run the query then, it should not find any records because 8:05, 8:30 and 8:55 are not 'on or after' Mon Jul ...

Views

773

Like

1

Replies

1
Re: Attempting to aggregate / count values from a temporary table
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HelloI've got a similar issue and I've done the suggested fix however now the Enrichment throws the following error:Any hints?I'm trying to group a temp schema based on Recipient's primary key and aggregating the number of "Opens" and "Clicks" from the Recipient tracking log. Temporary schema contains all records from the Recipient tracking log matched with a different schema.

Views

1.7K

Likes

0

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
My delivery is in status "Being edited" and has links in the tab you're showing, however still cannot find it in the TrackingUrl schema. Any idea why it isn't appearing?

Views

871

Likes

0

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Jean,could you explain/show please how do I achieve that "Published" status? I created a test delivery with some HTML content (links included), but I cannot make it appear in the xtk:trackingUrl schema.

Views

899

Likes

0

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
Hi JeanThanks for answer.Doesn't the xtk:trackingUrl schema contain only entries from already sent deliveries? I wanted to check it prior to sending.

Views

875

Likes

0

Replies

0
Scan HTML content for URLs and cURL them
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HiI'm working on a solution that would scan planned deliveries for URLs (in their HTML Source) and cURL those URLs and check their HTTP Response. Goal is to avoid sending campaigns with broken URLs.Now, I have the 2nd bit (cURLing) complete, however I cannot figure out how to obtain all the URLs (and img src URLs) for the cURL activity.I've tried RegEx to check the [content/html/source] in nms:delivery and was working but it's not a recommended solution (safety wise) and for more complicated HTM...

Views

2.3K

Like

1

Replies

6
createElement - document.createElement is not a function.
Avatar

szymons55769873

szymons55769873
- Adobe Campaign Classic
HiI'm trying to use the following method in my workflow, in JS activity: createElement When I start the workflow and check the logs I get the error: document.createElement is not a function.How do I use it?I'm trying to scan certain deliveries, within their HTML source code, for all the links and check the HTTP Response of them before starting the delivery.I need to create a DOM in order to use it later with querySelectorAll var doc = [];doc = document.createElement("div");doc.innerHTML = fromDB...

Views

2.6K

Like

1

Replies

2
Likes given to
Likes from