About Shui

Shui · 06-08-2022

I am using Data Stream (IntegrationHub) Data Source to import JSON data from a 3rd party site. I would like to use the response body directly as the action output, instead of creating and parsing each child item since there are many child items and s...

Shui · 07-11-2022

Hi Pardhiv, Are you able to solve the issue? I encountered the same error when I tried to deploy to another instance, Unable to load headers from the XLSX data source ( scheduled import job: XXXXXX). In my case, the import completed with error and no...

Shui · 06-09-2022

I thought of that. But there was no duplicates of the coalesce column in the import file though. And I cleared the import set and target table, and ran the same import again, and all are inserted in import set this time.

Shui · 06-09-2022

Thank you, Richard for your suggestion. Data stream (IntegrationHub) is a little different. I there is no data pill to drag for the action output. Here is the Script Parser step. Here is the Outputs step. When I ran text, the Output item is emp...

Shui · 06-07-2022

Hi gj, Thank you for this post and solution. My data stream action is very similar to yours. I also have an Array.Object in the action output (like groups in your action) and I have same code in the script parser step, however, my array.object field ...

Shui · 06-01-2022

I am having a similar issue. I imported/transformed about 2K records to an empty target table. All records were inserted to the target table, the number of records in the Import Set matches that of the target table. However, when I looked at the Stat...

User Activity

Data Stream (IntegrationHub) Action Output

Re: Unable to load headers from the XLSX data source ( scheduled import job: XXXXX)

Re: Transform Map: Ignored Row Still Inserts Target Record

Re: Data Stream (IntegrationHub) Action Output

Re: PAGINATION - DATA STREAM (Item Path)

Re: Transform Map: Ignored Row Still Inserts Target Record