sdelano
New Contributor II
Joined 9 years ago
User Profile
User Widgets
Contributions
Passing a custom sql server data type into a stored procedure
Given the below sql server procedure definition excerpt. How would we pass in an array of data into this this datatype as the input parameter of the stored procedure. when passing in a straight array of values we get the following error. “reason”: “Expected value in type:BUID_LIST for parameter:@BUIDS, but got value:[(‘U00003601’), (‘U00007346’), (‘U00011341’), (‘U00011468’), (‘U00019947’), (‘U00026075’), (‘U00027687’), (‘U00038315’), (‘U00041258’), (‘U00043454’)] in type:ArrayList.” /* type dbo.BUID_LIST as TABLE ( BUID nvarchar(20) not null ); go */ CREATE PROCEDURE [dbo].[UpdateHousingStudents] – Add the parameters for the stored procedure here (@BUIDS dbo.BUID_LIST READONLY, @Results nvarchar(200) OUTPUT) AS BEGIN2.6KViews0likes1CommentUsing Soap UI to call soap wsdl in snaplogic
Hi All, I’ve created a pipeline that accepts a soap call and returns appropriate information back. I can use Soap execute in snaplogic to call it and return the output. I can also use postman to call it with a post and get results. The problem is with SOAP UI. I cannot get soap ui to authenticate with the Snaplogic server. Neither the cloud plex nor our groundplex. I was wondering if anyone out there has had a similar issue and how did they conquer the problem. Thanks Sean1.9KViews0likes1CommentFind Array index from object value in the array object getindex?
I have a json file with an array designed like below. I don’t have control over the number of or order of address entries. I have tried $.Address.findIndex(x => x == ‘Home’) and $.Address ? (value.AddrType = Home) among other expression language statements. I would like to query the array by AddrType and get the index of the matching array entry record. Has anyone done something similar. We are attempting to normalize<<>>denormalize records based on types to denormalized fields that correspond to the types. {fnam:“Joe”,Lname:“Long”, Address:[ { “AddrType”: “Mailing”, “StreetAddr1”: “123 Prospect Street”, “City”: “Waltham”, “State”: “MA”, “Zipcode”: “” }, { “AddrType”: “Main”, “StreetAddr1”: “123 Baystate Street”, “City”: “”, “State”: “”, “Zipcode”: “”, } ]4.6KViews1like2Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
